Limited text field length

[ST]

I have a table with a field datatype memo. When I created
a query that retrieve from this table, the field's data
was truncated to 255 characters (from 300 characters in
the table).

How do I maintain data when create this query?

What is the text limit on the textbox control in reports?
Can it display more than 255 characters?

Thanks for your help!

 

[John Spencer (MVP)]

Memo fields get truncated if you use any aggregate functions in the query. Or
use a UNION query. Or use any formatting on the memo field. Or ...

Also, you cannot use any formatting on the control in the report.

Can you post the SQL of your query?