Growing form when opened with acDialog

Question

I open the form with this command:

DoCmd.OpenForm "frmGraphData", acFormDS ,, acDialog, "A" and Me.OpenArgs

When I created the form, I save it in the size that I want. But the form grows every time I open it. After a while, the bottom of the form just goes below the screen.

This is not a modal, not an independent window.

I would like to force the form to retain its original size. How can i do this?

thanks

Answer 1

The easiest (possibly brightest) way to handle this is to set the width of the form in an open event. This will do the trick, but may give the developer problems with anger management.

Private Sub Form_Open(Cancel As Integer) DoCmd.MoveSize , , 6000, 6000 End Sub