blank last page

  • Thread starter Thread starter Wim
  • Start date Start date
W

Wim

Hi,

I have a report where I use grouping with 2 group headers
and 1 group footer. I have a page eject in this group
footer. The report does what I want it to do, but : when
printing I get a blank last page. Can I prevent this ?

Thanks in advance,

Wim
 
Wim said:
I have a report where I use grouping with 2 group headers
and 1 group footer. I have a page eject in this group
footer. The report does what I want it to do, but : when
printing I get a blank last page. Can I prevent this ?
Click to expand...

Assuming your report footer section is either nonexistent,
invisible or has a Height of zero, here's some ideas to try.

Instead of the Page Break control in the group footer, set
the group footer's ForceNewPage property to After Section.
It might be better to Set the group header's ForceNewPage to
Before Section, instead.

If your situation won't permit either of those solutions,
then you may have to resort to using code in the group
footer's Format event. First make sure you have a text box
somewhere that refers to Pages in its expression (e.g.
="Page " & Page & " of " & Pages), then the code would be
something like:

Me.thepagebreak.Visible = (Me.Page < Me.Pages)
 
Marsh,

There are data in the footer, so height is greater than 0.
I however clicked the ForceNewPage property in the After
Section and it works.

Thank you very much,

Wim
 
Wim said:
There are data in the footer, so height is greater than 0.
I however clicked the ForceNewPage property in the After
Section and it works.
Click to expand...

It is the REPORT footer that must not be just blank space,
not your group footer. If you have a visible, non-zero
Height report footer with noting in it, Access will have to
print that blank area after your last page break.
 
Back
Top