access的查询导致长文本数据缺失_Access report文本框只显示较长的查询结果的255个字符(Access report text box only displays 255 charac...

I have what seems to be a common issue but the specifics are a bit different than other questions available. Working in a MS Access 2016 database on Windows 10.

I have a query performing a UDP function Coalesce which combines Long Text from multiple records into a single String. The query does not appear to be limited in size at all – I can view the correct output of hundreds of characters.

However when i try to display this in a report, in a text box with Can Grow, only the first 255 characters are visible. (Text box is growing correctly)

There is no formatting at all set to this text box, and it is set to Plain Text (so it can shrink, which apparently Rich Text cannot do. Also Rich text has the same problem)

Many solutions center around getting the query to return more than 255 characters (Why a Long Text field is returning only 255 characters in a MS ACCESS 2013 query?) – I do not have this problem. The query is ok.

Many solutions center around a record source from a table of type Short Text, or a query from a Short Text field (Access report field truncating at 255 characters). This is also not my problem since a) the original source field is long text, it is processed through a UDP which outputs a String type, and the query result is >255 characters.

Help!