Macro to set Paper Size = Legal

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

Guest

I would like to write a macro for the Open Report event to automatically set
the Paper Size of the report to Legal and the Orientation to Landscape. Can
anyone help?
 
Hi,
i am not sure you can do this with macro, but using VBA you can:
"You can use the PrtDevMode property to set or return printing device mode
information specified for a form or report in the Print dialog box"
 
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

Open Report Event 1
Printing both letter and legal page sizes in one document 2
How to Columnate Memo on Report 1
Can Code Set Page Setup 1
How to get a report to default to a default printer... 3
Mattter typed on Legal paper want to get it on A4 size paper 1
Cannot Change Report Page Size Access 2007 1
How can I maximize the size of a Picture on a Printed Page? 1

Back
Top