Setting Report's Zoom on open

[smig]

How can I set the report's Zoom on open, and set the window size to match the report's zoom?

 

[theDBguy]

Hi. You could try something like:

DoCmd.RunCommand acCmdZoom200

 

[smig]

Hi. You could try something like:

DoCmd.RunCommand acCmdZoom200

Thanks, but what about the window size ?

 

[theDBguy]

Thanks, but what about the window size ?

Maybe try DoCmd.MoveSize?

 

[smig]

Hi. You could try something like:

DoCmd.RunCommand acCmdZoom200

Not working
I tried Report's Open, Load, Activate events

 

[theDBguy]

Not working
I tried Report's Open, Load, Activate events

"Not working" as in, are you getting an error message? If so, what does it say? Otherwise, can you post a sample db to demonstrate what you want to do? Thanks.

 

[smig]

"Not working" as in, are you getting an error message? If so, what does it say? Otherwise, can you post a sample db to demonstrate what you want to do? Thanks.

Sorry

error 2046 - The command or action 'Zoom200%' isn't available now

 

[theDBguy]

Sorry

error 2046 - The command or action 'Zoom200%' isn't available now

Hmm, I just tried the following on a form button and it worked for me.

Private Sub Command0_Click()

DoCmd.OpenReport "Report2", acViewPreview
DoCmd.RunCommand acCmdZoom200

End Sub

Is that what you did?

 

[smig]

Hmm, I just tried the following on a form button and it worked for me.

Private Sub Command0_Click()

DoCmd.OpenReport "Report2", acViewPreview
DoCmd.RunCommand acCmdZoom200

End Sub

Is that what you did?

No, I tried the Report's Open, OnLoad... events

This is even makes it easier for me as I don't have to change the reports, only the commands open them

Thanks

 

[smig]

what is the exact difference between:
acViewNormal
acViewPreview
acViewReport

 

[theDBguy]

what is the exact difference between:
acViewNormal
acViewPreview
acViewReport

Hi. Normal sends the report directly to the printer. Preview displays the report before printing. And Report displays it in Layout view.