Preview report at minimum zoom??

[Guest]

I have a form that generates a search results. I have a button on that form
that opens a report in preview to display the same search results, thanks to
suggestions provided in this forum.

at present the report opens such that all the report cannot be viewed in the
report pane without clicking the mouse to reduce the level of zoom. My
question is this, is it possible to have the report open at this minimum
level of zoom by default when my user clicks the form button.

Thanks again for your continuing support,
Ian.

 

[fredg]

I have a form that generates a search results. I have a button on that form
that opens a report in preview to display the same search results, thanks to
suggestions provided in this forum.

at present the report opens such that all the report cannot be viewed in the
report pane without clicking the mouse to reduce the level of zoom. My
question is this, is it possible to have the report open at this minimum
level of zoom by default when my user clicks the form button.

Thanks again for your continuing support,
Ian.

When you open the report from the form....

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

Also available are acCmdZoom25, acCmdZoom50, ...etc... acCmdZoom 1000

 

[JohnC]

And I like:

With DoCmd
.OpenReport "ReportName", acViewPreview
.Maximize
.RunCommand acCmdFitToWindow
End With

 

[Guest]

Thanks very much to Fred and John, both very elegant solutions and just what
I needed.

Ian.

And I like:

With DoCmd
.OpenReport "ReportName", acViewPreview
.Maximize
.RunCommand acCmdFitToWindow
End With