Memo Field on Report

  • Thread starter Thread starter Allan Koodray
  • Start date Start date
A

Allan Koodray

I am trying to print a memo field on a report. However,
one of the memo fields happens to be greater than 255
characters. The report shows only the first 255, then
truncates the rest. The properties are set to Can Grow /
Can Shrink (not that it makes much of a difference. Is
this just an Access limitation, do I need to change a
setting or is there a programtic way to resolve the issue?

Allan Koodray
 
Make sure your report's recordsource displays more than 255 characters in
its datasheet view. If it doesn't, you may need to remove words like
"DISTINCT" and "GROUP BY".
Another common issue is a value in the Format property of the text box.
 
Back
Top