force report to open in landscape

[Gumbo78]

I use SQL to create a query, save the query to a string then print the report. The report template I use needs to be landscaped (many fields and I need the room.) Many users use my program and have their page/printer options set differently. Is there a way to make the report open in landscape when you give the command?

DoCmd.OpenReport stDocName, acViewPreview, , strWhere

Is my current statement. I cant find anywhere in the help or constraints to force it to allways open in landscape. I dont really want to use the application.printer.(etc) command because I'd like the user to have their settings like they like them, just have my report open in landscape view. Is this possible?

 

[dhookom]

Open the report in design view and then set it for landscape printing. Move a control a little and then close and save the report. If the Landscape is not saved then you are probably using Access 2000 without the latest service pack installed. There is a quick fix for this.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.