Problems with Form On Resize Event

[i2cmevans]

I want to have my form load a different image size when the form is resized beyond a certain WindowHeight. The form's On Resize event seemed like the perfect place for the code, but it seems that this event fires off constantly or at least several times when the form is resized and it really fouls things up. There is a ResizeEnd event in VB but this doesn't work in VBA apparently.

Does anyone have any suggestions on how I might go about firing an event when a user finishes resizing the form window?

Many thanks.

 

[boblarson]

What code are you trying to use? And yes the resize event does keep firing at particular intervals as the size changes.

 

[i2cmevans]

What code are you trying to use? And yes the resize event does keep firing at particular intervals as the size changes.

The code that I want to run is actually for a video control. When the form window is scaled to a larger size I need to send a stop command to the video, then give it new resolution parameters, then start the video again. I tested the code with a button event so I know it works, but when I run it through the On Resize event it freezes up the video control because of the multiple firings of the event. The gist of the code is as follows...

If Me.WindowHeight > 4000 Then
StopVideo
AssignNewParameters
RestartVideo
End If

 

[boblarson]

I can't think of a way to deal with this situation at the moment. I'll keep pondering it but I'm not sure I can think of a way around your problem. So, how important is it for your users to be able to resize this form?