How do program a report to open and have it zoom to 100% instead .

G

Guest

Hi,
I have a report in a access database and want to preview it every time,
before printing it.
I have created a button to open the report but it always opens in Fit to
window mode. This is as good as usless as I cant read it to see the results
and so alwways have to enlarge it with zoom to 100% on the toolbar. I have
tried to use the on open event on the report to open it in zoom 100% but cant
seem to get it right. It says toolbar is not availiable when I try to use
domenu or runcommad
any help most apreciated.

using access 2000

Steve
 
A

Allen Browne

Try putting the code into your command button, e.g.:

DoCmd.OpenReport "MyReport", acViewPreview
RunCommand acCmdZoom100
 

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

Similar Threads

Zoom to 100 Percent on Open Report Event 12
How to open Reports with bespoke zoom setting 2
MS Access, control zoom property on Open Reports 4
How to best select from image and print full size? 1
Add zoom control to report status bar 3
How to code report to automatically zoom to 125% 4
MSAccess How do I set the default report view zoom level to 100% 1
Custom report preview toolbar 3

Top