How to Make a Form Sizable

[EddieN1]

I have a form with a List Box that I want to open in Dialog mode. It is normally a small form, however, sometimes it may contain a larger List Box than normal. As a minimum, I would like to give the operator the option of making the form bigger. If possible, I would also like to give the user the option of making the List Box bigger.

[Missinglinq]

...I would like to give the operator the option of making the form bigger...

Can't do that if you're going to open it in Dialog Mode! The question, I guess, is what is your reason for using this mode? Maybe we can come up with a workaround to accomplish all of your goals.

Linq ;0)>

[EddieN1]

It doesn't have to be in dialog mode. I just want the operator to answer these form before going anywhere else.

[June7]

You set Dialog mode by code in the DoCmd.OpenForm method? This is useful if you want to open form and suspend code execution until form closes. Otherwise, the Modal property setting will prevent user moving to another form. However, I find Modal and Popup settings an aggravation when debugging.

How will the user 'resize' form? Grab and Drag corner? or button click? Resizing the listbox would mean setting the Height property.

[EddieN1]

I would like to have them grab and drag corner.

[June7]

Then set the BorderStyle property to Sizable. However, that will do nothing for the listbox.

[Missinglinq]

You can set the Modal and Popup Properties in the Property Pane of the Form in question, then open it with

DoCmd.OpenForm "YourTableName", , , , , acWindowNormal

and the Form can be re-sized and, as June7 said, the Form will have to be dealt with before moving elsewhere .

Linq ;0)>

[EddieN1]

Found it... in the Load Event, put...

Private Sub Form_Load()

' Right, Down, Width, Height
DoCmd.MoveSize 2040, 1260, 8000, 8500

End Sub

Note Each measurement is in inches or centimeters, depending on the regional settings in Windows Control Panel.