In the page footer of a report, I have the following controls:
txtPage: ="Page " & [Page] & " of " & [Pages]
lblDCApproval (a label)
linDCApproval (a line for a signature)
lblDate (a label)
lblDate (a line for a date of signature)
In the OnFormat and in the OnPrint events of the page footer, I have the following code:
These controls are initially set to Visible = False.
My goal is to have the signature controls print only on the last page. Here is the issue: in the print preview, it functions as expected. When I print the report, the controls appear on every page. How do I get it to print only on the last page?
Phil Edwards
txtPage: ="Page " & [Page] & " of " & [Pages]
lblDCApproval (a label)
linDCApproval (a line for a signature)
lblDate (a label)
lblDate (a line for a date of signature)
In the OnFormat and in the OnPrint events of the page footer, I have the following code:
Code:
If [Page] = [Pages] Then
Me.lblDCApproval.Visible = True
Me.linDCApproval.Visible = True
Me.lblDate.Visible = True
Me.linDate.Visible = True
End If
These controls are initially set to Visible = False.
My goal is to have the signature controls print only on the last page. Here is the issue: in the print preview, it functions as expected. When I print the report, the controls appear on every page. How do I get it to print only on the last page?
Phil Edwards