Open Report Event

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

Guest

Is there code I can run when a Report opens that will set the Paper Size to
Legal and the Orientation to Landscape? Thanks
 
It is done with the printer object:
application.Printer.PaperSize =

Look in VBA Help for PaperSize for more details
 
You must log in or register to reply here.

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

Macro to set Paper Size = Legal 1
Can Code Set Page Setup 1
How to Columnate Memo on Report 1
Control Page Setup of a Report through Coding 5
How to get a report to default to a default printer... 3
Problem With Default Settings For HP 8250 Printer 2
code to set page orientation to print form or report 1
Set Print Options 2

Back
Top