Print Report

[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.

 

[Allen Browne]

Set the Display When property of the button.

Care to explain how you have created a functioning button on your report?

 

[Guest]

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