Sizing the Report Preview pane?

[Guest]

I have a user who'd like a certain report, when open in Preview, to be
somewhat larger than the size normally generated by the preview. Due to
operational restrictions, I cannot maximize the preview pane, and as you know
the text is very small in the preview pane.

He wants the size of the report in that pane to be customizable as to size.
So if I want to open Preview at 50% of normal report size, that'd be ideal.
Is there a way to do that via VBA?

Thanks!

 

[fredg]

I have a user who'd like a certain report, when open in Preview, to be
somewhat larger than the size normally generated by the preview. Due to
operational restrictions, I cannot maximize the preview pane, and as you know
the text is very small in the preview pane.

He wants the size of the report in that pane to be customizable as to size.
So if I want to open Preview at 50% of normal report size, that'd be ideal.
Is there a way to do that via VBA?

Thanks!

Open the report via code using:

DoCmd.OpenReport "ReportName", acViewPreview
DoCmd.Runcommand acCmdZoom50

 

[Guest]

That worked great! (used 75 rather than 50). Now, how can I size the preview
pane to be physically wide enough to show the zoomed report? Any ideas?

 

[Guest]

DoCmd.MoveSize 1, 1, 14000, 9000

You might need to mess with the last two numbers to get it right.