Removing the Minimise Button

[Tim L]

Hiding things (1)

I've tried searching the Modules and VBA threads but what I want doesn't seem to have been covered.

I can't get rid of the minimise button that appears on the menu bar (despite having set "Min Max Buttons" to "None").

This means that the user can resize the window to its smaller state (making a right mess of the screen) and can't put it back (although every form that opens automaticaly maximises, so that doesn't last long). This is more of a cosmetic problem, but one that I feel should be solveable for someone more au fait with Access than I am...

Other form settings are:

Control Box: No
Close Button: No

Any ideas?

Tim

 

[ghudson]

Do not maximize your forms if minimizing them will create problems. Set your forms to the custom size you want and set the forms properties to Popups and Modal.

Search this "forum" when researching the common questions and you will probably find your answer in numerous threads.

Searching this forum for the keyword "size" will bring up a lot of threads. One of my respones was this...

The InsideHeight & InsideHeight properties will allow you to set the forms size. Add this to the forms OnOpen event to display and set the forms size.

MsgBox "InsideHeight = " & InsideHeight & vbCrLf & vbLf & "InsideWidth = " & InsideWidth
InsideHeight = 4605
InsideWidth = 7950

HTH

 

[Tim L]

There are a couple of problems with this unfortunately.

When I tried setting my main form to pop-up it promptly took over the whole screen, including the task bar, not something that I am, or the users no doubt would be, very pleased about. This has the added disadvantage of hiding the menu bar. (Would adding my custom menu bar to each form individually solve this problem, I wonder?)

I can't control the resolution of the screens on which the database will be used, I therefore don't know what the appropriate size would be (and don't know how to query the system to find out what the current size is - this is getting complicated...

Tim

 

[pbaldy]

This is a M$ "feature":

http://support.microsoft.com/default.aspx?scid=kb;en-us;210299&Product=acc2000

 

[boblarson]

If you want the form to stay the same size always, then you can go into the resize event and put in:

Docmd.Restore

That will keep them from minimizing, maximizing or resizing.