Memo Field on Report

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
 
D

Duane Hookom

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.
 

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
Maximum Report Field Size? 2
conditional format truncates memo field 1
Size of memo contro on report 2
Memo Field is truncating to 255 Chars 6
Memo field is truncating in group heading of an Access 2007 report 3
Memo in Report causing blank pages/other issues 2
Reports: memo field won't display more than 255 characters 1

Top