Print Report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to have a print button on a report yet not have the button
actually printed out. I have a fuctioning print button on the report but I
don't want to see it on the printed report.
 
Set the Display When property of the button.

Care to explain how you have created a functioning button on your report?
 
This is how.
******************************************************
Option Compare Database
Option Explicit

Private Sub cmdCaseRptMainPrint_Click()

On Error GoTo cmdCaseRptMainPrint_Click_Error

DoCmd.PrintOut

On Error GoTo 0
Exit Sub

cmdCaseRptMainPrint_Click_Error:

MsgBox "Error " & Err.Number & " (" & Err.Description & ") in procedure
cmdCaseRptMainPrint_Click of VBA Document Report_rptCaseReport"

End Sub
 
Back
Top