memo fields not printing completely

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

 

[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

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?

 

[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

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

 

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