A field in my Access query is not displaying all avail info

J

Joy

I have created several queries from other queries and then a report from the
final mismatch query. The mismatch query doesn't display all the information
in a field. It is cutting off at a particular point in the field.
 
A

Allen Browne

If any of the queries used by the report are asked to GROUP BY the memo or
perform any other aggregation, Access returns only the first 255 characters.

As an example of working around this, if you have a Totals query, try
setting the Total row under the memo field to First. You will have to change
the field name of the report to something like "FirstOfMyMemo", but it
enables Access to return all characters.
 
Top