Form Size

[Tony Williams]

Is there anyway of stopping a form from maximising? I have a number of small
forms which fit in the centre of the screen. However if the user
inadvertently maximises any screen then all the forms seem to maximise. I
want them to stay the same size all the time. I've looked through the Help
and can't find anything on this.
Does anyone have an answer?
Thanks
Tony

 

[Arvin Meyer [MVP]]

Remove the maximize and minimize buttons from your forms and they will stay
in their Restore state when they get focus.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Tony Williams]

Thanks Arvin
Tony

Remove the maximize and minimize buttons from your forms and they will stay
in their Restore state when they get focus.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Tony Williams]

Sorry Arvin that doesn't seem to work either.
If I have 2 forms forma and formb, formb has no min or max buttons and I
want it to stay the same size. If the user opens forma and maximises to see
it all then closes it the next time formb opens it is also maximised. That's
my problem?
Tony

 

[Penguin]

Try adding DoCmd.Restore in the OnClose of the form.

 

[Tony Williams]

Thanks Penguin I'll try that
Tony

Try adding DoCmd.Restore in the OnClose of the form.