Field Being Cut Off

[tasha]

I have a memo field in a sub-report that is being cut off. I've checked the
text box format properties and they were all automatically set with the
exception of Can Grow which is set to Yes. I've also checked the report
properties and the Keep Together is set to Per Column. Is there something
else I should be checking for? I'm being cut off at about 240 characters.

Thanks

 

[Marshall Barton]

I have a memo field in a sub-report that is being cut off. I've checked the
text box format properties and they were all automatically set with the
exception of Can Grow which is set to Yes. I've also checked the report
properties and the Keep Together is set to Per Column. Is there something
else I should be checking for? I'm being cut off at about 240 characters.

If it's being cut off at 255 characters, then it might be
because the text box has something in its Format property.
If that's not it, open the report's record source query
without using the report to see if the data is getting to
the report.

If not, fix the query. The usual reasons why a memo field
is truncated are when the memo is included in the sorting,
grouping or if the DISTICT predicate is used.