eliminating blank space

T

talib

Hello Access Nation

I've created a report in which I have hidden the
duplicate entries. When the report runs I'm left with
blank space between the entries in the detail section.
How can I eliminate this blank space. It make my report
over 200 pages long and filled with large empty spaces.
Any and all help is much appreciated. Thanks.
 
A

Allen Browne

You will need to eliminate the duplicates before they reach the report.

Base the report on a query.
In query design view, open the Properties box (View menu).
In the Query Properties, set Unique Values to Yes.
 
J

Jeff Boyce

In addition to Allen's suggestion, have you already set the CanGrow and
CanShrink properties of the control(s) and section to "Yes"?
 
Top