I have a comments field in a table that is set as MEMO. The form shows all the text in the comments section. The report with this same field is cutting off the comments part way through. The box itself is large enough to hold all the text. Is there a limit to the number of characters the text box on the report can hold? If so, why does it all show up in the text box on the form?

I need a quick answer as the PE's are breathing down my neck for their reports.

Thanks so much.

Lori :confused:

You probably have tried this but here goes.

In your report design view select the text box for your memo and open its properties, under the format tab try changing the option can grow from no to yes.

HTH
Cillies

I have this same problem, although when I enable the 'can grow' field, the text still gets cut off. I think what's (frustratingly) happening is the text box isn't showing more than 255 characters even though the field it is displaying is a memo field.

A label can probably display the amount of text, but it can't be bound to the memo field.

Has anyone been able to find a way around this issue?

Thanks,

Scottie.

Have you seen this web page (http://allenbrowne.com/ser-63.html) by MVP Allen Browne?

Thanks for showing me that R.G, gives a good explanation of why it's only displaying 255 characters.

I'll use UNION ALL!

Thanks again for your help!

Excellent and you are welcome.