printing Access report without seeing report first

**ketchu1j** · Oct 9 '15, 08:31 PM

I have been trying to use a command button in Access to print a report to the default printer without showing the printer selection screen first. I finally got it to do that using the following code that I found from someone else on your site...

Code:

Private Sub Command29_Click()
    DoCmd.OpenReport "rpt_stamp_label", acViewNormal, , , acHidden
    DoCmd.PrintOut acPrintAll
    DoCmd.Close acReport, "rpt_stamp_label"
 
End Sub

The problem I am having is that each time it prints the report, it also prints out a screen shot of the form that the button is activated from. Can anyone help me so that only the report prints?