eliminating blank space

  • Thread starter Thread starter talib
  • Start date Start date
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.
 
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.
 
In addition to Allen's suggestion, have you already set the CanGrow and
CanShrink properties of the control(s) and section to "Yes"?
 
Back
Top