Form events

pavel · April 19th, 2004, 01:44 PM

Hi.
Could anyone tell me what event to use after I change .Visible from False to True? I need to trigger my function every time Form is visible.

Thank you.
Pavel

jrwlkn · April 19th, 2004, 03:57 PM

CAN YOU BE MORE SPECIFIC AS TO WHAT IT IS YOU WANT TO DO

marcostraf · April 20th, 2004, 12:31 PM

VB forms do not expose a OnVisible event (as well as many others we wish it had). You have two choice, as far as I know: subclass you form and find the right event, or just put a timer (half a seconds or so should be enough) that checks when the me.visible changes. Remember to enable the timer in the Load event and disable it in the unload. You can find good subclassing components at a reasonable price, chip ones so so, and very bad for free. If the application is simple and you feel to have enough time, you can also roll your own.
Marco

SerranoG · April 22nd, 2004, 07:06 AM

There is no ON VISIBLE event in Access, so what you have to do is at the time you actually change the visible property of the control, then you ALSO run the code you want. For example, let's say you have a textbox and you want a button to be visible if the textbox is not null, You would put this on the textbox's AFTER UPDATE event:

Code:

Me.cmdMyButton.Visible = Not IsNull(Me.txtMyTextBox)

But then you want some other code to happen for the button, but there's no ON VISIBLE event for the button. You'll have to take care of it at the textbox's AFTER UPDATE event along with making the button visible/invisible:

Code:

If IsNull(Me.txtMyTextBox) Then
   Me.cmdMyButton.Visible = False
   'Run some other code here
Else
   Me.cmdMyButton.Visible = True
   'Run some other code here
End If

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division