Keeping a form maximised after closing a report

[hooby1]

Does anyone know why when you click on a command button that loads a report it shows it in a print preview mode and then when you click close it closes the report window and changes the form that you were originally on to a much smaller and condensed view instead of being maximised? All the properties are making the form to maximise except when you close from a print preview view. Cheers

 

[ghudson]

docmd.restore

should fix it back

 

[HARDCASE1234]

this is the code I have currently and it is not working, this is at the end of the code does it need to be else where?

Private Sub Form_Resize()
DoCmd.Restore
End Sub

 

[Tieval]

Personally I would put it on the On-Close of the report