Collapse a report

[samotek via AccessMonster.com]

I have a report in table design and the first textbox in the row is productid,
etc. The rows in my reports are shown blank, since there is no productid, but
there are some other textboxes in the row showing some figures. Is it
possible not to show any rows where the productid is not shown ? I have made
the Shrink properties to yes also in the design view, but it doesnt help

 

[Evi]

Labels and Lines do not shrink. If you have a Line in there, delete it or
make it invisible with VBA - same with labels if you need to keep them.
We'll tell you how if you're not sure.
..
Make sure that not only the controls but also the Section has Can Shrink set
to Yes.
Evi