Dynamic Report Landscape Orientation

[J360]

I'm using VB in Access 2003 to generate a dynamic report. I first open the report in design view to set all the grouping levels etc. I then use

 with rpt 
           .printer.orientation = acProrlandscape
            ...
          End With 

I then open and display the report using docmd and acviewpreview.

The report opens everytime in Portrait, although the page setup is correctly set to Landscape. If I manually view the report in design view and then go back to print preview, the Landscape settings finally take effect.

Does anyone know what I should do that it automatically opens in Landscape? The end users can't be trusted to click in and out of design view.

[ADezii]

If you have Access 2002 or above:

1. Open the Report in Hidden Window Mode
2. Change the Report's Orientation
3. Print the Report
4. Close the Report

DoCmd.OpenReport "<Report Name>", View:=acViewPreview, WindowMode:=acHidden
Reports("<Report Name>").Printer.Orientation = acPRORLandscape
DoCmd.OpenReport "<Report Name>"
DoCmd.Close acReport, "<Report Name>"

[J360]

Thanks, but i need to open the report in Print Preview mode rather than opening it normally. Because of this, I keep getting an error that I can't set the orientation in the subreport when i set orientation in design view as you suggested.

Any other suggestions? I tried to write some code that sets landscape, and then switched between design and preview views in the hopes it would replicate physically clicking, but this doesn't work. One currently must see it in portrait, click design, and click back to view it in landscape.