Setting a report's page orientation using vba


A

ACM-DB

Is it possible to set a report orientation to portrait or landscape using VBA,
before printing - perhaps in the OnOpen event module? I'd like to change the
orientation depending on the selected report.

Appreciated!
 
Ad

Advertisements

S

SA

ACM:

To reliably change the orientation, you have to open the report in design
mode rather than at run time. This can be accomplished using VBA. Look at
our web site under the Code and Design Tips under the reports section for
the code you need.
 

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