Setting a report's page orientation using vba

  • Thread starter Thread starter ACM-DB
  • Start date Start date
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!
 
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.
 
Back
Top