Report does not print all Data

  • Thread starter Thread starter Richard VanHorn
  • Start date Start date
R

Richard VanHorn

I have a Memo feild that contains data that shows up in
the Table, Query but gets cut off in the Report.

Does anyone have any suggestions?? (My can grow is on,
but the words are cut off on the end)
 
Richard said:
I have a Memo feild that contains data that shows up in
the Table, Query but gets cut off in the Report.

Does anyone have any suggestions?? (My can grow is on,
but the words are cut off on the end)
Click to expand...

You're a little short on details here, but if the memo is
being truncated at 256 characters, then there are several
possible causes.

If the report section is not set to CanGrow then it might be
preventing the text box from growing.

Run the report's record source query from the query design
window. Check if the memo is truncated before it ever gets
to the report. If it is, then the problem in the query can
be caused by the use of:
DISTINCT option
UNION
including the memo field in a GROUP BY or ORDER BY clause

If the query contains the entire memo field, then check the
report. A common cause of this truncation is specifying a
Format property for the memo field's text box. Specifying
the memo field in the Sorting and Grouping window may also
be a problem.
 
Back
Top