Set Print Orientation in Access VBA

J

jhrBanker

I've added a button to an Access Form to print the form. However, it prints
in Portrait and won't fit on the page. I've added the code "Let
Printer.Orientation=vbPRORLandscape", but am receiving the error "Invalid
Procedure call or argument". I want this to work for the Default Printer.
Any suggestions? Full code is:

Private Sub cmdPrintForm_Click()
Let Printer.Orientation = vbPRORLandscape
DoCmd.PrintOut
End Sub

Would appreciate any help. Thanks
 

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

Similar Threads

Set Print Orientation to Landscape 1
print with Landscape orientation 1
Problem printing tab pages 0
Multiple Page Report with Different Orientations 2
PrintOut Code Error 2
Print to PDF in VBA Code 11
Trying to Print "Client Receipt" form per client visit 2
Show Access Print Dialog to Ask for a Printer 1

Top