Michael Brösdorf
michael.broesdorf at web.de
Tue Jun 24 13:32:53 CDT 2003
Dear group,
I am still having problems with my form resize code. I have a subform in the
detail section of a form. The form header is ampty and the form footer
contains a couple of command buttons.
The main form is resizable and the size of the subform should be adjusted
accordingly. That works fine for the most part.
But: If a user drags the _upper_ edge of the window towards the bottom of
the window, the window moves downward. If the upper edge reaches the initial
position of the lower edge the window suddenly jumps around and I get an
error message 2100 (Control or subform too big...).
Any ideas are much appreciated!
Here is the complete code of the form's resize event:
Private Sub Form_Resize()
On Error GoTo PROC_ERR
Const clngMinH = 5600
Const clngMinW = 8500
'Debug.Print Me.InsideHeight, Me.WindowHeight, Me.InsideWidth,
Me.WindowWidth
'Debug.Print IsIconic(Me.hwnd)
'Check if form has been minimized
If IsIconic(Me.hwnd) <> 1 Then
'Enforce minimum height of form
If Me.InsideHeight < clngMinH Then
Me.InsideHeight = clngMinH
End If
'Enforce minimum width of form
If Me.InsideWidth < clngMinW Then
Me.InsideWidth = clngMinW
End If
'Set height of detail section
Me.Section(0).Height = Me.InsideHeight - 800
'Set height/width of subform
Me.sfrmList.Height = Me.InsideHeight - 800 - 2 * Me.sfrmList.Top
Me.sfrmList.Width = Me.InsideWidth - (2 * Me.sfrmList.Left)
End If
PROC_EXIT:
Exit Sub
PROC_ERR:
Select Case Err.Number
Case 2100:
'Ignore this error
Case Else
myErrMsg Err, Me.Name & ":Form_Resize"
End Select
Resume PROC_EXIT
End Sub