Setting Orientation in VBA

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

Guest

Is there a way that you can set the orientation of a report to "Landscape" in
VBA? Setting it in "Page Setup" is not keeping the value. So I want to set it
in VBA when I call the report.

Thanks for any help.

-Charles
 
If that setting does not hold, it might be one of the Name AutoCorrect
listed here:
http://allenbrowne.com/bug-03.html

If you are using Access 2002 or 2003, you can change the orientation once
the report is open in preview with:
Reports!Report1.Printer.Orientation = acPRORLandscape
 
Thanks!
This code worked perfectly. It was a tremendous help because we were going
nuts!
 
Back
Top