Control Box

[Chuck]

I have converted from Access 2003 to 2007 and noticed the control box is
still available on the form when its maximized. I've changed the form
properties for control box, minimum and maximum, to NO, but the function of
restore is still available in the control box. Problem is when a user
selects restore, the form disappears and no chance of redisplaying it. Is
there a way to completely remove the control box from a form, preventing the
restore option?

 

[Arvin Meyer MVP]

What I do is to create a background color the same color as the border. The
I place a box on the form a bit smaller than the form and place my controls
on top of the box. Then I change the borderstyle to none. Now only my
controls can control the form. I use the following code in the form's on
open event to prevent it from maximizing due to opening from a maximized
form:

DoCmd.Restore