How to open Reports with bespoke zoom setting

M

Miles

Use a form with report buttons and form code
(DoCmd.RunCommand acCmdZoom75) to open report with
standard zoom setting of 75%.

Would prefer (first choice) 'Fit' or (second choice) 70%
but get a runtime error unless my code uses one of the
standard numerical zoom settings from the toolbar.

Any way to get 'Fit' or a non-standard zoom setting?

TIA
 
M

Marshall Barton

Miles said:
Use a form with report buttons and form code
(DoCmd.RunCommand acCmdZoom75) to open report with
standard zoom setting of 75%.

Would prefer (first choice) 'Fit' or (second choice) 70%
but get a runtime error unless my code uses one of the
standard numerical zoom settings from the toolbar.

Any way to get 'Fit' or a non-standard zoom setting?

I don't think there is a reasonable way to get a custom zoom
factor.

You can get it to fit by using
DoCmd.RunCommand acCmdFitToWindow
 
M

Miles

Why didn't I try that; many thanks!
-----Original Message-----


I don't think there is a reasonable way to get a custom zoom
factor.

You can get it to fit by using
DoCmd.RunCommand acCmdFitToWindow
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top