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