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)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.If [Page] = [Pages] ThenMe.Label28.Visible = TrueEnd If
Me.Label29.Visible = True
Me.Label30.Visible = True
Me.Label31.Visible = True
Me.Label32.Visible = True
Any suggestions how I can overcome this?
I am using Access 2003
Thanks in advance