Hi,

I have a number of labels that I want to print at bottom of the last page of my report. They are all placed at the page footer section (I can't place them in the report footer, as they will not always be placed at the bottom or the page).

The labels' properties are all set to visible = No and then I have the following code in the Page Footer Section:

Private Sub PageFooterSection_Format(Cancel As Integer, FormatCount As Integer)

If [Page] = [Pages] Then

Me.Label28.Visible = True
Me.Label29.Visible = True
Me.Label30.Visible = True
Me.Label31.Visible = True
Me.Label32.Visible = True

End If

End Sub

When I preview the report, they only show on the last page as required, However, when I print a hard copy, the labels still print at the bottom of each page.

Any suggestions how I can overcome this?

I am using Access 2003

Thanks in advance

This post has been edited by spooker: Apr 23 2012, 05:38 AM

Also add your code to the On Print Event of your report.

Thanks for that - did the trick...

....now why didn't I see that? (IMG:style_emoticons/default/dunce.gif)