Form re-sizing

[Paul Micklethwaite]

Hi, I'm a web developer doing some Access dvelopment and
it's driving me mad! My problem is the way Access
automatically resizes forms/windows. I have 2 linked forms
created using the form wizard. I want the first to open up
maximised - I've used Docmd.maximise on the form open
event and this works fine. When I click the button to open
the linked form I want this form to open up as it is sized
in design view (as a modal window). However, it opens up
maximised. I can put a docmd.restore on the open event for
this second form which works okay but it also resizes the
first form. I've played around with all the properties but
haven't been able to achieve the desired effect - am I
missing something simple?

 

[ScottE]

Check out http://peterssoftware.com/winmanip.htm. It's a
sample db with a lot of window sizing effects. It sounds
like one routine in that db, called "xg_SizePopUpForm",
could be used to resize (vs maximize) the first window.

Hope this helps!

 

[Rick Brandt]

Hi, I'm a web developer doing some Access dvelopment and
it's driving me mad! My problem is the way Access
automatically resizes forms/windows. I have 2 linked forms
created using the form wizard. I want the first to open up
maximised - I've used Docmd.maximise on the form open
event and this works fine. When I click the button to open
the linked form I want this form to open up as it is sized
in design view (as a modal window). However, it opens up
maximised. I can put a docmd.restore on the open event for
this second form which works okay but it also resizes the
first form. I've played around with all the properties but
haven't been able to achieve the desired effect - am I
missing something simple?

Try opening Word and have two documents open at the same time. Then try to
maximize one of the documents without maximizing the other one. You can't
do it. You can't do this in Excel with multiple files open either.

Access is the same way. Maximize one object and you maximize all objects.
The exception is with forms having the Popup property enabled. Often you
can play with that setting to get the desired affect.

 

[Greg Kraushaar]

Thats the way Access works. Forms and reports are child windows of
Access, and the Window State is common to them all You might get
around the isue by making the second Window a popup modal dialog box.
Its been a long time since I was playing with this

Why not simply size both Windows how you want them and leave them both
restored.. If you want to make allowances ofr different screen
resolutions, it is possible to read the screen size, and set the form
size to suit, but it is "difficult " code. If you want to play with
tis, Buy Ken Getz's books. it is explained well in there.

 

[Guest]

Thanks for these suggestions. I discovered after I sent my
original post that setting the second form to be a popup
achieves the desired effect.