So I took out all the labels
But I have a field that is invisable, then on top of that I have a formual.
Then I have a subreport that I have done the same with.
How do I get the subreport to do the same?
I don't want any blank pages.
Thanks

"Ken Sheridan" wrote:

The control will still shrink regardless of the hidden control If there is
anything visible alongside the shrinkable control, however, then it won't
shrink. For instance if you have a label you want to hide if a control
shrinks if it has no data then you should hide the label by putting code in
the relevant section's Format event procedure, e.g.

Me.MyLabel.Visible = Not IsNull(Me.MyBoundControl)

The bound control will then shrink to nothing if Null and the label will be
hidden.

Ken Sheridan
Stafford, England


"Chey" wrote:

Stupid question, but If you make something invisable, then on top of that
have a field, that is can shrink. Does that count, or will it not shrink
above the invisable text box?