Limited text field length

  • Thread starter Thread starter ST
  • Start date Start date
S

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!
 
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?
 
Back
Top