Report in 100 Zoom

[rgsw]

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!

[MMcCarthy]

Put the following line of code after the Report Open command

DoCmd.RunComman d 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!

[rgsw]

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.OpenRepor t "Query2", acViewPreview, "", "", acNormal

[rgsw]

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.OpenRepor t "Query2", acViewPreview, "", "", acNormal

Never mind finally figured it out. Thanks this works.