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"?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Eliminate Duplicates In A Report 2
Blank space appears in report section. 2
Sub Report placement 1
Displaying blank space when no data in subreport 5
Remove extra space in a Report 1
Extra space on reports 1
Blank detail section 2
extra blan page 4

Back
Top