Problem showing Page Footer in MS-Access 2000

[mtho]

I am developing a report in MS-Access 2000, where I have a label that should appear only on the last page. So I have written the following code in the PageFooter OnPrint Event.

Private Sub PageFooterSection_Print(Cancel As Integer, PrintCount As Integer)
If [Page] = [Pages] Then
LabelName.Visible = True
End If
End Sub

In the Report Preview, the label appears only on the last page(as expected) but when I print it, it prints on all pages.

Any help is appreciated

 

[hymn]

have a look at thread703-585493

Hope this helps
Hymn