Monday, April 05, 2004

Your boss wants a signature panel at the bottom of the last page of an MS Access report. Try this technique:

1. For the Signature panel, place a TextBox control named, txtSignature, in the PageFooter section of the report, format it as required, and set the Visible property to False. Save the report.

2. In the report's module, add the following code to the OnPrint Event, so that the Signature Panel is visible only on the last page of the report:

Private Sub PageFooter_Format(Cancel As Integer, FormatCount As Integer)
If Me.Page = Me.Pages Then
Me.txtSignature.Visible = True
Me.txtSignature.Visible = False
End If
End Sub

No comments: