size of report when opening

[Notsogood]

Every time I open the report it is a different size. How can I make sure that the report always opens large enough to fill the screen?
Thanks

 

[Ally]

Go to the properties of the report, and on the OnOpen Event enter a procedure DoCmd.Maximize

It should look like this:

Private Sub Report_Open(Cancel As Integer)
    DoCmd.Maximize
End Sub

If you're not sure about properties and code, post back. HTH

 

[Notsogood]

Thanks for the suggestion.

It worked but can I get rid of the scroll bars on the bottom and side please?

 

[Ally]

Just checked one of mine and if the report is bigger than "fit to screen" it will have scroll bars. These won't print out.

 

[Rich]

DoCmd.RunCommand acCmdFitToWindow

 

[Ally]

Thank you Rich.