Resizing a dialog form

[Guest]

I'm opening a form using the docmd.openform command. It looks like:

DoCmd.OpenForm "ZoomWindow", acNormal, , , , acDialog

I open it as a dialog to give a modal window, in other words, the user must
address the window and close before returning to the main window. However,
when I open the form as a dialog I lose the ability to resize the window. If
I take off the acDialog I can resize the window, but it is no longer modal.

Does anyone know how I can get a modal window that is also resizable?

 

[Cameron Sutherland]

Instead of mixing your property setting with the form's
properties and your line that calls it do both in the
properties of the form being called. That is, set the
forms modal and pop-up properties to Yes and it will act
like a dialog only you can resize it. The only down side
to it is the acDialog method you were using can be really
usefull because it stop executing any code on the form
until the user closes the dialog form. My method will
continue executing code after the openform call.
-Cameron Sutherland

 

[Guest]

Thanks, somehow I missed the modal property for the form. That did the trick.