It seems a page footer is the other option. I was leaning towards using a Report Header to display relevant data fields for the report in an effort to maximize real estate. Too bad I can not have a Report Header without a Report footer.
Using the page footer option I have this....
Move contents of Report Header to Page Header
Move contents of Report Footer to Page Footer
Delete Report Header/Footer
Write some VBA to conditional format my signature line labels.
Code:
Private Sub PageFooterSection_Format(Cancel As Integer, FormatCount As Integer)
Dim intPageCurrent As Integer
Dim intPageCount As Integer
intPageCurrent = Me.Page
intPageCount = Me.Pages
If intPageCurrent = intPageCount Then
Me.lblChecked.Visible = True
Me.lblDate.Visible = True
Me.lineSig.Visible = True
Else
Me.lblChecked.Visible = False
Me.lblDate.Visible = False
Me.lineSig.Visible = False
End If
End Sub
I think this works OK. The other option I described in post #1 would be to keep the Report Header/Footer and create an entire page dedicated as a signature page. I could add the information from the Report Header and maybe some other fields to the signature page. It still does not look right though. Using Page footer with formating looks more profesional in this particular case.