Interesting problem. I’m loading up some data in Access that includes a memo field that could potentially contain many K of information. I created a report and eventually noticed that not all of the memo field was being outputted! Very odd.
A quick Google search found a post by Allen Browne that described the issue and the solution. Simply put, I had noticed that Access had added an @ format for the field in question when I pasted to create the table from Excel. The @ format copied down to the report level. That code, and several other conditions as described by Allen, will cause Access to truncate the memo output to 255 characters to save CPU effort.
I guess it makes sense, 20 years ago, when CPUs were considerably weaker. Now? I’m not so sure that it’s needed.