Help...need to set report's Orientation to landscape in the VBA! 1

[Labadore]

I have a report that opens but doesn't seem to hold the landscape option. It switches back to Potrait every time I open the report. I've decided that the reports on open event should have hard coded into it to open in landscape view for the preview of the report and the printing of the report. If anyone knows how to set this in the code (VBA), please let me know how. Thank you in advance for your time and help.

Labadore

 

[Store300]

In excel its ActiveSheet.PageSetup.Orientation = xlLandscape

You're going to tell me its for Access aren't you? Store300

Store300@ftnetwork.com

 

[Labadore]

Your right. It is for access, not excel. If you know what it is for access, write me back. thanks for your help Store300... s-)