Forcing Landscape on DoCmd.OpenReport

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

Guest

Reports!Report1.Printer.Orientation = acPRORLandscape

The above code does a great job on opening a report in the landscape mode.
With "Report1" being the name of the report. My question is how do your write
code to do the same thing but when the name of your report is a variable?

Reports![Report_Name].Printer.Orientation = acPRORLandscape

Does not work. Anyone have a solution they would like to share?

Thanks.
 
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

can't print in landscape 2
Stop header/footer appearing in subreport 1
Using Subreports to create a Main Report 7
OnFormat action not executed when exporting to PDF 2
Access Report With Portrait and Landscape Settings 0
OBJECTIVE: Print PDF to file, each record should be a file name =PID (field) - have code issue belo 2
Print Report to PDF by Group _ Name by Group? 1
Force landscape mode... 1

Back
Top