hiding boxes but pring blank pages

[AJ]

I have a form based upon a query from a table. The record the report is
based upon has 3 fields that contain data, not all always have data. I have
created the report to populate based upon a maximum of 3. I have included on
the detail portion of the report the code to hide all the cells not needed
when those fields are empty. While long and combersome, it is working.

However, my report still prints those pages as blank pages with the reporter
and footer even when all the cells are not visible.

Any thoughts/suggestions on how to not print those pages when everything on
the page is there but not visible?

thanks in advance

 

[Duane Hookom]

Consider making th text boxes very short and allowing them to expand.