I have a report with many, many controls on it, but not all of them are visible. They are only set to visible if the fields have data in them. So, in design view my report length is fairly long (15 inches), in case all fields are populated. However, if all fields aren't populated, the report is still the same length. Is there anyway to determine or to define the length of the report??? just so when I print it there wont be blank pages on the end.

I also have a form with the same prob.

Thanx in advance