There is one text box I want to hide when the Report Footer page is reached. This text box should appear on all pages except when the is reached. I can't find an event that will change the text box visible property to false only the last page. I've tried this.
Code:
Private Sub ReportFooter_Format(Cancel As Integer, FormatCount As Integer)
Me.txtFacilityTitle.Visible = False
Me.txtFacilityName.Visible = False
End Sub
and this. Neither works. I prefer to keep the FacilityName on the Page Header, but when it displays on the Grand Total page it is confusing and inaccurate. My only other solution is to put it in the Facility Group Header, but for cosmetic reasons I would rather not.
Code:
Private Sub ReportFooter_Paint()
Me.txtFacilityTitle.Visible = False
Me.txtFacilityName.Visible = False
End Sub