Blank page at the end of report (no margins problem)

[joostdevr]

In an Access report I've created, the last page is always blank (so
not every other page, only the last one). This is very strange
considering the fact that I've set both page headers and footers and
they don't appear on this page.

Now I've checked all margins, both "can shrink" and "can expand"
options and I really can't seem to find where this problem is coming
from.

Another strange fact is that in preview mode (and in report preview
mode) I don't see this blank page, it's just there when I print the
report.

Can anyone tell me what I'm missing here? Thanks a bunch!

 

[Al Campagna]

Joost,
I just replied to a similar post, but involving a blank page at the
beginning of the report...
Try my suggestions, but in regards to the ReportFooter instead of the
Header...

Without being able to see the report itself, I'll assume the problem lies
within the Report Header... since that only fires once per report, and you
only get just one blank page at the start of the report.

In Design mode, place the cursor in your ReportHeader section, and...

Check that you have no PageBreak inserted in that section.
Also check that you have Force New Page = None, and New Row Col = None.

A shot in the dark... but that should be checked first.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."