Memo field truncated in query/report?

  • Thread starter Thread starter gordon robinswood
  • Start date Start date
G

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
 
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.
 
Back
Top