Memo field truncated in query/report?

[gordon robinswood]

Hi,
I have a report based on a query. The query grabs a memo
field from my main table, yet when I display the memo
field in the report it truncates the memo field (the field
needs to hold more than 255 characters). The table
displays all the memo text, but the query seems to
truncate the memo field to 255 chars?

It seems like there should be a relatively easy fix, but I
can't seem to find it.

Any ideas/help would be most appreciated.

Thanks,
Gordon

 

[Allen Browne]

If your query does any grouping on the memo field, Access takes only the
first 255 characters.

For example, if the query has a GROUP BY clause, use "First" instead of
"GroupBy" under the memo field. You will need to change the Control Source
of the text box on your report to something like FirstOfMyMemo, but it
should display all the characters.