How to prevent form from Maximizing?

[SF]

Hi,

I have two forms, Form01 and Form02. Form01 serves as screen background so I
mazimize it every time the mdb is open. When I try opeing Form02, it
maximize so the look of Form02 is not good. Is there a way to open Form02
without maximizing it while retaining Form01 maximize?

SF

 

[Douglas J. Steele]

Hi,

I have two forms, Form01 and Form02. Form01 serves as screen background so I
mazimize it every time the mdb is open. When I try opeing Form02, it
maximize so the look of Form02 is not good. Is there a way to open Form02
without maximizing it while retaining Form01 maximize?

No there isn't. Since Access is an MDI interface, Maximize applies to all
forms.

 

[John Spencer (MVP)]

Only way I know is to open Form02 as a popup form. I ***THINK*** that this will
work. I've not tried or tested it.

You need to set the POP-up property of the form to true. That property is on
the "Other" tab of the properties pane. Or you can use code

Forms!Form02.Popup = True

This may not be a solution you can use, but it may do what you want.

 

[TmanT]

Along with John's solution, you could also set the form's property 'Min Max
button' to Min Enabled which also prevents users from maximizing your form.

Hope this help

Tony

 

[Damon Heron]

Dont maximize form01. Just make it large, and set border style to none.
Also, set movable to no, no min/max buttons, no scroll bars, no close
button, etc. You have to add a command button to close the app, of course.
By not maximizing, all forms that are called from form01 will not
maximize....

HTH
Damon

 

[SF]

Thank you for all your valuable ideas. I will adjust my forms accordingly.

SF