Form re-sizing

  • Thread starter Thread starter Paul Micklethwaite
  • Start date Start date
P

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?
 
Paul Micklethwaite said:
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?
Click to expand...

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.
 
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.
 
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.
 
Back
Top