[ASAP] GotFocus event

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

in my current access vba project I have to set a textbox's '.text' property
to a specific value:

txtTest1.SetFocus
txtTest1.Text = ""

Now, when I run this code, the GotFocus handler of txtTest1 is called - how
can I prevent this? How can I erase a textbox's text property without calling
the GotFocus handler?

Thanks
Peter
 
Well, you can't. What you could do, though, is use a module level flag to
control whether code in the GotFocus event should run ...

mFlag = True
txtTest1.SetFocus
txtTest1.Text = ""

In the GotFocus event ...

If mFlag = True Then
mFlag = False
Exit Sub
End If

But why do you need to set the Text property? Is there a reason why you
can't set the Value property (which does not require that the control have
focus) instead of the Text property?
 
Thanks for replying! All I want is to clear a textbox so that the user can
enter a new string. So, when I set value to "", does the textbox appear to be
empty?

Thanks
Peter
 
Yup! :-)

--
Brendan Reynolds (MVP)


Peter Schmitz said:
Thanks for replying! All I want is to clear a textbox so that the user can
enter a new string. So, when I set value to "", does the textbox appear to
be
empty?

Thanks
Peter
Click to expand...
 
Back
Top