text box in report is truncating memo field at 255 characters

[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

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

--
Duane Hookom
Microsoft Access MVP

"Paul" wrote:

> .
>

[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

"Duane Hookom" <duanehookom@NO_SPAMhotmail.com> wrote in message
news:7FCC8E3C-9795-4944...@microsoft.com...