Text field being truncated in reports

P

pas926

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
 
D

Duane Hookom

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

text box in report is truncating memo field at 255 characters 2
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Field Being Cut Off 1
Memo field is truncating in group heading of an Access 2007 report 3
Memo field cuts text 1
Size of memo contro on report 2
Maximum Report Field Size? 2
Textbox Truncated 1

Top