Set "Zoom" on opening report

[Brian Snelling]

Greetings,
I'm having trouble writing a little VBA to set the zoom factor to 90%
when a report opens. Help files don't seem to help. Can someone point me
in the right direction?
TIA
Brian Snelling

Access 97
Windows 98

 

[Bob Barnes]

How about
DoCmd.RunCommand acCmdZoom90...
right after the DoCmd OpenReport statement

HTH - Bob

 

[Bruce M. Thompson]

How about

DoCmd.RunCommand acCmdZoom90...
right after the DoCmd OpenReport statement

Unfortunately, there is no RunCommand constant for 90% zoom (the above will not
work), so you must use a method dealing with custom zoom values. See the
following page at The Access Web for a solution:

Reports: Custom Zoom in Reports
http://www.mvps.org/access/reports/rpt0020.htm

 

[Bob Barnes]

Bruce - I was afraid of that. I didn't check as I was
Programmimg something else at the time. I have used
the acZoom75 before.

Bob

 

[Bruce M. Thompson]

Bruce - I was afraid of that. I didn't check as I was

Programmimg something else at the time. I have used
the acZoom75 before.

No problem.

 

[Brian Snelling]

Thank you , Bruce and Bob

Brian S.

No problem.