irglebleeben
asked on
Hide Min/Max button in Access 2003 forms
I'm working on an Access 2003 database. In the Form_Load of my forms i have a DoCmd.Maximize command. I want the forms to maximize and not have any control box or min/max buttons. The format settings are as follows:
Auto Resize - No
Auto Center - No
Control Box - No
Min Max Buttons - No
Close Button - No
In spite of these settings I still get a Min/Max button in the Access menu bar.
How can i get rid of this? There is also a Help field that is superfluous which says 'Type a question for help'. If I could get rid of this it would be helpful as well.
Auto Resize - No
Auto Center - No
Control Box - No
Min Max Buttons - No
Close Button - No
In spite of these settings I still get a Min/Max button in the Access menu bar.
How can i get rid of this? There is also a Help field that is superfluous which says 'Type a question for help'. If I could get rid of this it would be helpful as well.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
irglebleeben,
You can try this:
Border Style: Dialog
AutoCenter: Yes
ScrollBars: Nither
RecordSelector: No
And waaaaaaay down at the bottom of the Properties box…
Moveable: No
Now you have to adjust the form *Grid* dimension to just barely fit the screen.
Approximately 10.25in x 5.75in, for a screen resolution of 1024 x 768
(This allows for two toolbars on top)
On the Open and Activate events put:
Docmd.Restore
What all this will do is *Restore* the form, (meaning not maximized or minimized.)
Since you resized the Form grid, the form will *almost* fit the screen. (Maximize tends to always show the Min/Max buttons)
Since you set Movable to NO, users can’t move the form around.
Hope this helps as well
JeffCoachman
You can try this:
Border Style: Dialog
AutoCenter: Yes
ScrollBars: Nither
RecordSelector: No
And waaaaaaay down at the bottom of the Properties box…
Moveable: No
Now you have to adjust the form *Grid* dimension to just barely fit the screen.
Approximately 10.25in x 5.75in, for a screen resolution of 1024 x 768
(This allows for two toolbars on top)
On the Open and Activate events put:
Docmd.Restore
What all this will do is *Restore* the form, (meaning not maximized or minimized.)
Since you resized the Form grid, the form will *almost* fit the screen. (Maximize tends to always show the Min/Max buttons)
Since you set Movable to NO, users can’t move the form around.
Hope this helps as well
JeffCoachman
Maybe there's Code or a Macro that's changing the settings?
Good Luck!
Gary