Report Footer Align to Bottom of Last Page

[Vladimir]

Initially, I created ReportFooter and put some controls there. But
ReportFooter appear just after last GroupFooter on report and
therefore I moved controls to PageFooter. I start to find a way to
show it at last page only.

I find a solution:

Private Sub PageHeader_Format(Cancel As Integer, FormatCount As
Integer)
Me.Section(4).Visible = (Me.Page = Me.Pages)
End Sub

It works fine, even I open report in PrintPreview or print directly to
printer, BUT ... when I open report in PrintPreview and try to print
AFTER THAT, the PageFooter appear on ALL PRINTED PAGES !

Any ideas ? I'm using Access 97.

Thanks in advance !