Quote Originally Posted by RobDog888
You can also use code to set the orientation for the report printing upon its opening. That will definately solve the issue but will require them to enable macros too.
VB Code:
  1. Option Compare Database
  2.  
  3. Private Sub Report_Open(Cancel As Integer)
  4.     Me.Printer.Orientation = acPRORLandscape
  5. End Sub
I believe he has already tried that with very mixed results. I also, back in my Access reports days, tried that, it sometimes it worked and sometimes it didn't. The one and only way I ever got landscape to print consistently was to set landscape as default at the time I created the report. Programmatically changing it was hit and miss at best.