Prevent Switchboard from maximizing when reports are maximized

J

jsccorps

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

Lynn Trapp

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

Me.Restore
 
F

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
 
J

jsccorps

Thanks

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

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

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