TheSearcher
Registered User.
- Local time
- Today, 12:58
- Joined
- Jul 21, 2011
- Messages
- 342
I have the following code in the On Print event of my report footer:
The msgbox tells me that I'm on page 1 - but the controls are still visible (on a 1 page report). However, on a 2 page report it works correctly.
Any ideas why this would be happening?
Thanks in advance,
TS
Code:
Private Sub PageFooterSection_Print(Cancel As Integer, PrintCount As Integer)
If Me.Page = 1 Then
MsgBox Me.Page
Me.[lbl_ClientName_Footer].Visible = False
Me.[txt_ClientName_Footer].Visible = False
Else
Me.[lbl_ClientName_Footer].Visible = True
Me.[txt_ClientName_Footer].Visible = True
End If
End Sub
The msgbox tells me that I'm on page 1 - but the controls are still visible (on a 1 page report). However, on a 2 page report it works correctly.
Any ideas why this would be happening?
Thanks in advance,
TS