How do you display memo fields on a report that exceed 254 char

[sk8er1]

I have a listbox with two columns that get populated from memo fields. I will need to put these onto a report.
The data will exceed 254 characters on a few records.
Question is...how do i handle that when I display the data in text boxes on a report....

 

[GingerR]

Displaying a memo field? Shouldn't be a problem. Are you having a problem with it?

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html

 

[sk8er1]

How would you display the value contained in a memo field on a report. Would'nt you use a text box?? And dont text boxes have a limit of 254 characters???

 

[AlexMidd]

Have you actually tried this? I have and it appears to show the full text no problem. I think you are thinking fo the text "field" when you mention the 255 char limit.

Have fun! )

Alex Middleton

 

[GingerR]

Text Box" is just what the type of control is called on a report (vs. "Line" or "Label", etc). You just make it's control source be a memo field or a text field, and voila. Set the Can Grow property to YES so it will expand to the height it needs to be.

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html