Forcing Landscape on DoCmd.OpenReport

C

cbjames

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