how do I keep my report from truncating memo fields

G

Guest

i made sure the CanGrow property is enabled ("Yes"), but the report is still
truncating the memo fields, any solution?
thanks, ruby
 
D

Duane Hookom

Open the report's record source in datasheet view to see if the full memo
fields display. If not, you probably have phrases in your sql like
"DISTINCT", "DISTINCTROW", "GROUP BY",...

You also can't have any value in the Format property of the text box and the
section of the report needs to be able to grow.
 

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

Memo field truncating in report 3
Report truncating 4
Exporting to excel is truncating my data 2
How do I print complete variable length memo fields in reports? 1
CanGrow with Memo fields? 2
Memo Text Truncating 1
Memo Field Truncating in Word 3
Make Table Query Truncating Memo Field at 255 Characters 2

Top