resize of report preview

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Andreas - 19 Jan 2007 14:20 GMT

I call a preview of my report from within a form with the use of acpreview
option.
The report appears with default preview option "fit" which is very small.
How can I make it automatically apear larger or at least make the containing
window autoresize after I select another zoom level. I don't mind selecting
this myself but I want the window to resize itself accordingly

Reply to this Message

Al Campagna - 19 Jan 2007 16:13 GMT

Andreas,
Place this code right after the OpenReport method.
DoCmd.OpenReport "YourReport, acViewPreview
DoCmd.RunCommand acCmdZoom75
See RunCommand Method Constants in Help, for all the available Zoom values.

Signature

hth
Al Campagna
Candia Computer Consulting
Microsoft Access MVP - Candia, NH USA
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

>I call a preview of my report from within a form with the use of acpreview option.
> The report appears with default preview option "fit" which is very small. How can I make
> it automatically apear larger or at least make the containing window autoresize after I
> select another zoom level. I don't mind selecting this myself but I want the window to
> resize itself accordingly

Reply to this Message

Andreas - 19 Jan 2007 16:34 GMT

Yes, that would just set the zoom level.
More important to me is how to change the window size because it is always
very small. I could change the zoom manually but you need much more time to
resize the coordinates of the window.

> Andreas,
> Place this code right after the OpenReport method.
[quoted text clipped - 10 lines]
>> mind selecting this myself but I want the window to resize itself
>> accordingly

Reply to this Message

Marshall Barton - 19 Jan 2007 16:31 GMT

>I call a preview of my report from within a form with the use of acpreview
>option.
>The report appears with default preview option "fit" which is very small.
>How can I make it automatically apear larger or at least make the containing
>window autoresize after I select another zoom level. I don't mind selecting
>this myself but I want the window to resize itself accordingly

This kind of operation can be done in the form's code right
after the OpenReport line:

DoCmd.OpenReport . . .
DoCmd.Maximize 'or DoCmd.MoveSize . . .
RunCommand acCmdZoom150 'or acCmdFitToWindow

Check VBA Help for RunCommand acCommand constants to see the
other builtin zoom factors.

Signature

Marsh
MVP [MS Access]

Reply to this Message

Andreas - 19 Jan 2007 16:52 GMT

Ok, its:
DoCmd.RunCommand acCmdZoom100
DoCmd.MoveSize 6000, 0, 14000, 30000

Exactly what I wanted.
Thanks to al

>>I call a preview of my report from within a form with the use of acpreview
>>option.
[quoted text clipped - 14 lines]
> Check VBA Help for RunCommand acCommand constants to see the
> other builtin zoom factors.

Reply to this Message