Maximize Form

[Guest]

I have use the Docmd.Maximize code to maximize the size of one of the forms.
Unfortunately, after opening that form, subsequent forms when opened from of
the maximized form will be maximized as well. How do I control certain forms
to be maximized while others to be fixed size windows? Thanks.
ck

 

[Douglas J. Steele]

You can't really. As you've discovered, maximizing a form is intended to
maximize them all.

You could put DoCmd.Restore in the startup of the other forms, but that will
change the first form as well if it's still open.

 

[Alex White MCDBA MCSE]

If you change the type of some of the forms you can get them to not maximise
e.g. set the border style to dialog and that form should not maximise and
all other forms set to sizable will maximize.

 

[Douglas J. Steele]

You sure about that Alex? In a test I just ran, my forms with border style =
dialog were maximized as well.

 

[Alex White MCDBA MCSE]

Hi Doug,

Yep just tested it on access 2000 and my main form is maximised and I just
opened a dialog form and is not maximised I have just checked and I have the
popup=yes as well on that dialog form, so to the original poster set border
style=Dialog and popup=yes and it works, thanks for pointing out my
omission.

 

[Douglas J. Steele]

I suspect it's the popup=yes that makes the difference.

 

[Alex White MCDBA MCSE]

Yes popup=yes is all you need, if you have to border style to sizeable it
just does not look right (personal choice), but the border style does not
affect the maximizing issue.

 

[Bob Howard]

I'm not sure whether it's better or not, but I use BorderStyle=Thin and
Popup=Yes to achieve this.

Bob (@Martureo.Org)

 

[Guest]

Thanks for your suggestions and yes, you were all right. After experimenting
with border = thin, popup= yes, it achieved what I was trying to accomplish.
ck

 

[jason K]

You only need to set pop up not the border style , i just tested both option
in access 07 and setting the border style made no diffrence at all.