Stop my from from resizing when load

  • Thread starter Thread starter JP Bless
  • Start date Start date
J

JP Bless

When I load my form it maximizes itself. I want the form to show at the same
size (small window that I designed). Thanks in advance
 
You might try

DoCmd.Restore

HTH,
Debbie


| When I load my form it maximizes itself. I want the form to show at the
same
| size (small window that I designed). Thanks in advance
|
|
 
There are two things that will cause the form to maximize when opened. 1) It
is being told to through code or macro. 2) Access displays all windows
either maximized or restored. It doesn't allow mixing. So, if the window
that is currently open is maximized, the form will maximize when you open it
unless you issue a Restore command. Exception: If the form is opened as a
"pop-up", it won't do this. To open as a pop-up, use the acDialog Window
Mode argument in the DoCmd.OpenForm call. Opening the form as a pop-up has a
couple of other results also. 1) It will open the form as application modal.
This means that you will have to close or hide the form before you can do
anything else. 2) It will pause the code that opened the form until the form
is closed or hidden.
 
JP said:
When I load my form it maximizes itself. I want the form to show at
the same size (small window that I designed). Thanks in advance
Click to expand...

In Access (and Word, Excel) if you maximize one child window you maximize
all child windows. So... when you open this form are you doing so when
there is already some other object that is opened and maximized?

If you need to maintain the normal size when another object is maximized you
can set the Popup property to true.
 
Back
Top