Print Preview - default size question 1

[neillovell]

hi,
I have several buttons that allow the user to view many different reports, using the Preview Report option in the wizard. However each time a report opens the preview pane is very small so the user must maximise it, then zoom in with the magnifying glass. Can I change this so the pane always opens with specific dimensions, and/or zoomed in?

 

[PaulBricker]

Neil, after the openreport line put
DoCmd.RunCommand acCmdZoom75

This command comes with 10, 20, 50.....200 zoom. Check it out and see if one works.

You could also use
DoCmd.Maximize
and then in the close event for the report put
DoCmd.Restore

This works well also.

Paul

 

[neillovell]

Excellent! The close event for the report will be in another section of code won't it? Not by DoCmd.OpenReport right?

I'll go look.

 

[neillovell]

Oh I see, I was putting it into the main switchboard form, not the report itself.


cheers!

P.S. Got scared when MS Access crashed after implementing the changes!!!