Text field being truncated in reports

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a text box in a report whose control source is from a query. That control source is from a memo field. The text is cut off at 255 characters on the report How do I get all the text to show on the report. I'm using Access 2000. Anyhelp is appreciated. Thanks, Paul
 
About 90% of the time, this is caused by phrases like "DISTINCT",
"DISTINTROW", or "GROUP BY" in the query. There are ways around this. The
other 10% of the cases is from adding a value to the Format property of the
text box.

--
Duane Hookom
MS Access MVP


pas926 said:
I have a text box in a report whose control source is from a query. That
Click to expand...
control source is from a memo field. The text is cut off at 255 characters
on the report How do I get all the text to show on the report. I'm using
Access 2000. Anyhelp is appreciated. Thanks, Paul
 
Back
Top