Prevent Switchboard from maximizing when reports are maximized

[Guest]

When users maximize reports and then return to the switchboard the switchbord
is in the maximized mode (i.e., covers the entire screen). How can I prevent
this and keep it the original size?

 

[Lynn Trapp]

Add the following line of code to the Activate event of your switchboard.

Me.Restore

 

[fredg]

When users maximize reports and then return to the switchboard the switchbord
is in the maximized mode (i.e., covers the entire screen). How can I prevent
this and keep it the original size?

Code the Open event of the switchboard:

DoCmd.Restore

 

[Guest]

Thanks

The DoCmd.Restore on Activate worked (On Open did not)

(Me.Restore did not not work, it returned an error)

 

[Lynn Trapp]

Well, naturally DoCmd.Restore would work better...duh. The reason the
Activate event works, instead of the Open event, is that the Open event only
fires when you initially open the form. Since, in your case, the form was
already open, the Activate event is the logical place for it.