Blank page when using NewRowOrCol property

  • Thread starter Thread starter Joost
  • Start date Start date
J

Joost

In an Access 97 multi column report, I am using the NewRowOrCol AfterSection
propety in a group footer to nicely group the data in three columns per
page.

If the report consists of only three (or six, or nine) columns, however, the
footer will force a new column, and therefore a blank page will be added.

At this moment there is no report footer.

Is there a way to suppress the new column when there is no more data to
print.

TIA

Joost.
 
Joost said:
In an Access 97 multi column report, I am using the NewRowOrCol AfterSection
propety in a group footer to nicely group the data in three columns per
page.

If the report consists of only three (or six, or nine) columns, however, the
footer will force a new column, and therefore a blank page will be added.

At this moment there is no report footer.

Is there a way to suppress the new column when there is no more data to
print.
Click to expand...


I presume that the blank page is at the end of the report?
If so, then I don't think you can do anything about it
(except put something in the report footer so the page isn't
blank???).

It appears that After Section settings are not as smart as
the Before Section setting, at least in some arrangements.
Try setting the group header section's setting to Before
Section to see if it's any better.
 
Marshall Barton said:
Try setting the group header section's setting to Before
Section to see if it's any better.
Click to expand...

Tried this, and it works!

Didn't try it before because I thought it would force a blank column at the
beginning of the report.

Thank you for pointing me in that direction.

Joost
 
Back
Top