This answer was given by Allen Browne few month's ago
If the memo field is truncating after 255 characters, these are the things
to look for:
1. Make sure the report is not performing any grouping on the memo field.
Particularly it should not be listed in the report's Sorting'n'Grouping
dialog, with a group footer or header.
2. Make sure the report's query is not grouping on the memo field. It it is
a Totals query, try changing the Total row under the memo to "First" instead
of Group By". You will need to change the Name and Control Source of the
text box on the report as well: it will come out something like
"FirstOfMemo1".
3. Make sure the report's query does not include the DISTINCT keyword (i.e.
Unique Values set to Yes in the query properties.) This will also cause the
memo to truncate.
4. Make sure there is nothing in the Format property of the text box on the
report, and nothing in the Format proeprty of the memo field in the table.
These things cause it to truncate.
Of course, the memo could also be truncating because the text box on the
report is not big enough to show all the characters. Setting its Can Grow
property to Yes will help (assuming there is nothing else overlapping the
text box vertically on the report), and check that the (Detail?) section's
Can Grow is also set to Yes.
