Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Adding text to report before print

Status
Not open for further replies.

EELungs

IS-IT--Management
Jan 5, 2002
4
US
Is there a way in Access to add text to a report before priting. So when I hit the print report button can I be prompted to add text to the report in a certain field
 
I use this on an unbound field to prompt the user to add a suspense date:

Dim intx As Integer

Private Sub PageHeaderSection_Format(Cancel As Integer, FormatCount As Integer)

intx = intx + 1
If intx > 1 Then Exit Sub
Me.txtSuspenseDate = InputBox("Enter Meeting Suspense Date", "Enter Date")

End Sub Linda Adams
Visit my web site for writing and Microsoft Word tips: Official web site for actor David Hedison:
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top