Printing memo field in report

[Janet Russell]

I have a report that shows all information for an
individual employee. All the fields print on the report
just fine except for the memo field. Only part of the data
in the memo field prints. It looks like only the first
255 characters print, although I haven't actually counted
them. This makes no sense to me since it is a memo field,
not limited to 255 characters. All the data appears on
the form for data entry.

I've set the "Can grow" property for the field on the
report to "Yes", and the size allowed for the field to
print is much larger than that which is used when the
rerpot prints. How can I make all the data
print on the report?

 

[Duane Hookom]

Check the report's record source. If you don't see more than 255 characters
in the datasheet view then you will need to change the SQL of the query.
This usually involves removing phrases like "GROUP BY" or "DISTINCT" or
"DISTINCTROW"
The other cause of this is a value in the Format property of the text box.