I need to hide an image on the page footer of my report when pages are larger than 1
Posted on 2011-03-17
When printing my report, I need to hide the footer, image (Image73) when the page number is higher than 1.
I used a macro previously to run on printing the footer section, but I want to use VBA so that the code is embedded in the report.
I tried the following three ways to address the image's visibility.
The errormessage says "Runtime error 424. Object Required"
Private Sub PageFooterSection_Print(Cancel As Integer, PrintCount As Integer)
If Me.Page > 1 Then
' [Reports]![rptNurseryOrdersConfirmation]![Image73].[Visible] = False
' Me![Image73].[Visible] = False
' [Image73].[Visible] = False
Please point me in the right direction.