Setting printer properties

J

Jackster

When I run the follow code to print the "Envelope" report it overrides the
page setup settings for this report and pulls paper from the default bin and
not from the manual feed as I have saved it. I know I need to use the
PaperBin property setting but I can't figure out where it goes in the code
below. Help!

Dim RptName As String
RptName = "Envelope"

DoCmd.OpenReport RptName, View:=acPreview, WindowMode:=acHidden

With Reports(RptName)
Set .Printer = Application.Printers(cboDestination.ListIndex)
'cboDestination.ListIndex is a listing of printers installed on the user's PC
End With

DoCmd.OpenReport RptName, View:=acViewNormal
DoCmd.Close acReport, RptName, acSaveNo
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top