memo fields not printing completely

S

Sheila

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?
 
F

Fons Ponsioen

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?
 
S

Sheila

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
 
D

Duane Hookom

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