Report truncating MEMO column

[Guest]

I have a report that needs to print the entire contents of a memo column. The
con trol on the report has 'can grow' set to YES. The report source is a
table that has this field as a memo column. This table is built from various
queries and some VBA code. I cannot see anywhere where the truncation is
occuring. However, there is a UNION query involved. Might this truncate the
memo column? If so, how do I get around this?

Thanks.

 

[Marshall Barton]

I have a report that needs to print the entire contents of a memo column. The
con trol on the report has 'can grow' set to YES. The report source is a
table that has this field as a memo column. This table is built from various
queries and some VBA code. I cannot see anywhere where the truncation is
occuring. However, there is a UNION query involved. Might this truncate the
memo column? If so, how do I get around this?

Don't use a UNION query or any query operation that compares
the memo field such as DISTINCT, GROUP BY and ORDER BY.

If you are not using any other of those things, maybe you
can use UNION ALL instead of UNION.

If you can not eliminate the trunction in the query, then
remove the memo field and pick it up some other way. One
other way would be to create anopther query based on your
UNION query and JOIN that to the table with the memo field.
Another could be to sue a DLookUp expression in the report
text box.