blank last page

[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

 

[Marshall Barton]

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 ?

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)

 

[Wim]

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

 

[Marshall Barton]

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.

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.