re-size acDialog box

[TedMartin]

I use the Docmd.open form with acDialog parameter as I need to interrupt the code for the user to select some information before proceeding. Is there anyway to control the size of the dialog box as currently in a continuous form format, it only shows 3-4 records. The screen is large enough to hold probably 10+ comfortably. There are vertical scroll bars but I would like the dialog box to open with more than 4 records showing.

Thanks

 

[ghudson]

I prefer to customize and force the size of my forms with the InsideHeight & InsideWidth properties using the forms OnOpen event. I set my forms property to PopUp to NO and Modal to YES and I set the forms Control Box to NO and the Min Max buttons to NONE and the Close button to NO.

Private Sub Form_Open(Cancel As Integer)
On Error GoTo Err_Form_Open
    
    'just for testing
    MsgBox "InsideHeight = " & InsideHeight & vbCrLf & vbLf & "InsideWidth = " & InsideWidth
    
    InsideHeight = 5450 'twips is the unit of measurement
    InsideWidth = 7870
    
Exit_Form_Open:
    Exit Sub
    
Err_Form_Open:
    MsgBox Err.Number & " - " & Err.Description
    Resume Exit_Form_Open
    
End Sub

 

[TedMartin]

Thanks - I wasn't aware I could control the form size this way; I usually just Maximise.