Changing Report Print Preview Zoom Options in VBA

[MintChipMadness]

I set my report to open in print preview but I can't figure out how to change one of the ribbon options when the user enters. I would like the print preview to open in two pages zoom mode. Is there a way to hit an option in the ribbon on entry? Thank you for your help.

[orange]

see if this site helps
http://www.databasedev.co.uk/preview...acCmdZoom.html

[MintChipMadness]

The zoom stuff from the site doesn't work. When I change something like landscape mode and save the database the report defaults to it the next time but with the two pages it doesn't. I think the DoCmd.RunCommand acCmdPreviewTwoPages is the command but I can't seem to get it to work when a user enters print preview. I tried to get it to work in open report but it can't be done (or I can't figure it out).

[MintChipMadness]

I found the answer on the interweb. I listed the working code below.

DoCmd.OpenReport "Reportname", acViewPreview
DoCmd.RunCommand acCmdPreviewTwoPages

[orange]

Glad you have it working.