Form Sizing

[Guest]

I have a form displayed in the maximized view. When I select a command
button to open a smaller (modal) form, it also opens in the maximized view.
Is there any way to have the main form maximized, and smaller forms open in
the size that they're saved? I've tried "auto Resize" both yes and no, which
doesn't seem to make a difference. Does acViewNormal or acViewPreview in VB
have anything to do with it? Is there an "acKeepItTheWayISavedItDammit" code?

Thanks

 

[Van T. Dinh]

Since you want Modal, you can use the acDialog option in the OpenForm method
to open the second Form in Dialog mode to keep it at the normal size.

There are other methods also.

 

[Guest]

I have the same problem. I followed your instructions and the form opens up
in its correct size but the textboxes in this form contain no values. If I
set the WindowMode to acWindowNormal I get values in the textboxes but the
application window is maximized. Any solution?

Thanks

 

[Van T. Dinh]

This means that there are other codes that are executed after the Form's
opening to assign values or ControlSource to the Textboxes which are not
executed because other codes are paused when use Dialog mode.

In your case, you should you the normal mode but use the Form_Activate Event
to Restore the Form. If necessary, use the Form_Unload Event to Maximize so
that the other Form that will become active will re-appear as Maximized.