How to display a field into two colmuns?

[kbrad28 via AccessMonster.com]

I am not sure if anyone can help me with this, but I am trying to figure out
if it is possible to change a Single memo field to to display as columns? Any
help will be greatly appreciated.

Thanks,

Kbrad28

 

[Duane Hookom]

I would think you could use two text boxes side-by-side. Then fill the first
text box with the results of a function that search for a space prior to say
the 2000th character and the second with the remaining text.

If you want the two text boxes to approximately the same height, you would
need the function to find the middle character and then the first following
space to break your memo field into two pieces for the two text boxes.

 

[kbrad28 via AccessMonster.com]

Thanks for your help, but could you break down your answer a little further?
I am unsure on how to create the function to convert my memo field in to two
text fields.

I would think you could use two text boxes side-by-side. Then fill the first
text box with the results of a function that search for a space prior to say
the 2000th character and the second with the remaining text.

If you want the two text boxes to approximately the same height, you would
need the function to find the middle character and then the first following
space to break your memo field into two pieces for the two text boxes.

I am not sure if anyone can help me with this, but I am trying to figure out
if it is possible to change a Single memo field to to display as columns? Any

[quoted text clipped - 3 lines]

Kbrad28

 

[Duane Hookom]

Could you break down your request a little further ;-)
Do you want to break near a specific number of characters or divide into
closely lengthed sections?

Are you always going to want just two sections?

--
Duane Hookom
Microsoft Access MVP

Thanks for your help, but could you break down your answer a little further?
I am unsure on how to create the function to convert my memo field in to two
text fields.

I would think you could use two text boxes side-by-side. Then fill the first
text box with the results of a function that search for a space prior to say
the 2000th character and the second with the remaining text.

If you want the two text boxes to approximately the same height, you would
need the function to find the middle character and then the first following
space to break your memo field into two pieces for the two text boxes.

I am not sure if anyone can help me with this, but I am trying to figure out
if it is possible to change a Single memo field to to display as columns? Any

[quoted text clipped - 3 lines]

Kbrad28

 

[kbrad28 via AccessMonster.com]

Sure,

I have a report that has the following that is broken into separate group
headers:

Recipe Name
Recipe Description
Ingredients <-------- this is what I want to be in columns to look like

Item 1 Item 3
Item 2 Item 4

Instructions

The report is perfect except I can't figure out how to create the columns,
but I'm not all that sure if it is possible. I hope this helps. If not let me
know.

Thanks!
Kbrad28

Could you break down your request a little further ;-)
Do you want to break near a specific number of characters or divide into
closely lengthed sections?

Are you always going to want just two sections?

Thanks for your help, but could you break down your answer a little further?
I am unsure on how to create the function to convert my memo field in to two

[quoted text clipped - 13 lines]

 

[Duane Hookom]

It looks like your ingredients are separate records (at least I think they
should be). Are they actually a single text value in a memo field? If this is
a single memo field, have you considered normalizing your table structure so
each item is a single record in a related table?

--
Duane Hookom
Microsoft Access MVP

Sure,

I have a report that has the following that is broken into separate group
headers:

Recipe Name
Recipe Description
Ingredients <-------- this is what I want to be in columns to look like

Item 1 Item 3
Item 2 Item 4

Instructions

The report is perfect except I can't figure out how to create the columns,
but I'm not all that sure if it is possible. I hope this helps. If not let me
know.

Thanks!
Kbrad28

Could you break down your request a little further ;-)
Do you want to break near a specific number of characters or divide into
closely lengthed sections?

Are you always going to want just two sections?

Thanks for your help, but could you break down your answer a little further?
I am unsure on how to create the function to convert my memo field in to two

[quoted text clipped - 13 lines]

Kbrad28

 

[kbrad28 via AccessMonster.com]

Actually the ingredients are included in the single memo field. Can you
point to a sample of how to normalizing? Once I complete the changes is still
possible to make the single records of ingredients show as columns?

It looks like your ingredients are separate records (at least I think they
should be). Are they actually a single text value in a memo field? If this is
a single memo field, have you considered normalizing your table structure so
each item is a single record in a related table?

Sure,

[quoted text clipped - 28 lines]