Memo is truncated in report

  • Thread starter Thread starter Chris Martin-McNaughton
  • Start date Start date
C

Chris Martin-McNaughton

I have a memo field that goes over 255 characters and is cut off when
displayed in a report. The Text Box in the report is set to "Can Grow" and
when the text is manually copied into the same Text Box it works fine. Any
ideas on how to fix this?

Thanks,
Chris Martin-McNaughton
 
Chris Martin-McNaughton said:
I have a memo field that goes over 255 characters and is cut off when
displayed in a report. The Text Box in the report is set to "Can Grow" and
when the text is manually copied into the same Text Box it works fine. Any
ideas on how to fix this?
Click to expand...

Make sure neither the query nor the report control has a format property
assigned and make sure the query is not using DISTINCT or GROUP BY on the
memo field.
 
The query was using GROUP BY - its fixed and working now.

Thanks,
Chris Martin-McNaughton
 

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
Memo field is truncating in group heading of an Access 2007 report 3
Memo field truncating in report 3
conditional format truncates memo field 1
Report truncating MEMO column 1
Memo field being truncated 6
Report truncating 4
Maximum Report Field Size? 2

Back
Top