Determine if Form is Minimized

[illini]

Is it possible to determine if a form is minimized via VBA?

I have a form with a listbox which I would like to resize once a pop-up form has been minimized or maximized.

Thanks.

-illini

 

[lynchg]

You could try using the InsideHeight property of the form, I assume it would be zero if the form is minimized.

You should play around with that to see if it will work for you.

 

[SteveR77]

I believe this is what you are looking for.

http://support.microsoft.com/?kbid=210190

Hope this helps,

Steve

 

[illini]

I think a found a relatively simple solution which uses a form's WindowWidth property.

I discovered that when a form is minimized (at least on my database), the form's WindowWidth = 1920. So, here's the sub I developed to determine if a form is minimized...

Sub Determine_Form_Min()
For Each dbsform In Access.Forms
If Forms(dbsform.Name).WindowWidth = 1920 Then
‘Execute your code here
End If
Next dbsform
End Sub


-illini