Opening Report in "Fit" mode

  • Thread starter Thread starter Bill
  • Start date Start date
B

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
 
Bill said:
What is the code, and where do I place it, to get a
report to open in "Fit To Screen" mode, rather than
maximized?
Click to expand...

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
 
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


.
Click to expand...
 
Back
Top