text box in report is truncating memo field at 255 characters

  • Thread starter Thread starter Paul
  • Start date Start date
P

Paul

I've got a text box in a report that has a memo field as the control source.
I also have the Can Grow property of that control set to "Yes," but it
truncates the data in that field to a maximum of 255 characters.

How can I get this text box to display all the characters in the memo field
when the report prints?

Thanks in advance,

Paul
 
This question gets asked quite often. Did you check the record source query
to make sure it displays more than 255 characters? This would be caused by
phrases in your record source query like: GROUP BY, UNION, or DISTINCT.

If the query returns all characters then your issue might be with a value in
the format property or the text box residing in a group section of the report.
 
You're right, Duane, I had SELECT DISTINCT in the query. Once I removed the
DISTINCT, it displayed all the characters in the field.

Thanks for your help with this.

Paul
 
Back
Top