Link to home
Start Free TrialLog in
Avatar of irglebleeben
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.
Avatar of tbsgadi
tbsgadi
Flag of Israel image

Hi irglebleeben,

Maybe there's Code or a Macro that's changing the settings?

Good Luck!

Gary
ASKER CERTIFIED SOLUTION
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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