memo fields not printing completely

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've created a Access 2002 report with memo fields. The memo fields only display/print about 3 lines even when there are more characters in the field. I've selected yes on the Can Grow property, but no more than 3 lines will appear. Any suggestions?
 
Have you selected "can grow" yes for both the text box and
the report band?
Fons
-----Original Message-----
I've created a Access 2002 report with memo fields. The
Click to expand...
memo fields only display/print about 3 lines even when
there are more characters in the field. I've selected yes
on the Can Grow property, but no more than 3 lines will
appear. Any suggestions?
 
Yes. It's on both
----- Fons Ponsioen wrote: ----

Have you selected "can grow" yes for both the text box and
the report band
Fon
-----Original Message----
I've created a Access 2002 report with memo fields. The
Click to expand...
memo fields only display/print about 3 lines even when
there are more characters in the field. I've selected yes
on the Can Grow property, but no more than 3 lines will
appear. Any suggestions
 
Check the SQL of your report's recordsource. If you see phrases like "GROUP
BY" or "DISTINCT" or "DISTINCTROW", you may have to remove them.
 
Back
Top