text box in report is truncating memo field at 255 characters

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
 
D

Duane Hookom

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.
 
P

Paul

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top