By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,921 Members | 1,479 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,921 IT Pros & Developers. It's quick & easy.

Report in 100 Zoom

P: 29
Hi - I'm trying to figured out how to click on a report and have it already in 100% zoom instead of having always click on zoom to make report larger. Thanks!
Sep 3 '06 #1
Share this Question
Share on Google+
3 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
Put the following line of code after the Report Open command

DoCmd.RunCommand acCmdZoom100

Hi - I'm trying to figured out how to click on a report and have it already in 100% zoom instead of having always click on zoom to make report larger. Thanks!
Sep 4 '06 #2

P: 29
I converted the macro to VBA as shown below. Because I'm just learning VBA, I'm not sure where to insert the code you gave. Could you give an example. Thanks again!

DoCmd.OpenReport "Query2", acViewPreview, "", "", acNormal
Sep 4 '06 #3

P: 29
I converted the macro to VBA as shown below. Because I'm just learning VBA, I'm not sure where to insert the code you gave. Could you give an example. Thanks again!

DoCmd.OpenReport "Query2", acViewPreview, "", "", acNormal
Never mind finally figured it out. Thanks this works.
Sep 4 '06 #4

Post your reply

Sign in to post your reply or Sign up for a free account.