Opening Report in "Fit" mode

[Bill]

What is the code, and where do I place it, to get a
report to open in "Fit To Screen" mode, rather than
maximized?

Thanks
Bill

 

[Rick Brandt]

What is the code, and where do I place it, to get a
report to open in "Fit To Screen" mode, rather than
maximized?

Your mixing your terminology here. Fit-To-Screen has to do with the zoom
level of the report within the preview window while Maximize has to do with
the size of the preview window itself.

I assume you mean you want Fit-To-Screen instead of 100% which is the
default zoom level when you preview a report. Unfortunately you cannot
manipulate the zoom level in the code module of the report itself. You
have to do so from the code that is opening the report (assuming that you
are using code to open it).

The syntax is...

DoCmd.OpenReport "ReportName", acViewPreview
DoCmd.RunCommand acCmdFitToWindow

 

[bill]

thats what I was looking for. Thanks much

-----Original Message-----


Your mixing your terminology here. Fit-To-Screen has to do with the zoom
level of the report within the preview window while Maximize has to do with
the size of the preview window itself.

I assume you mean you want Fit-To-Screen instead of 100% which is the
default zoom level when you preview a report. Unfortunately you cannot
manipulate the zoom level in the code module of the report itself. You
have to do so from the code that is opening the report (assuming that you
are using code to open it).

The syntax is...

DoCmd.OpenReport "ReportName", acViewPreview
DoCmd.RunCommand acCmdFitToWindow


--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com


.