I am quoting Allen Browne who answered my question:
"The memo will be truncated if you use a source query that involves any
aggregation (e.g. a GROUP BY clause or DISTINCT predicate in a SQL
statement), or formatting (e.g. UCase(), or something in the Format property
of the memo field in the...