[ASAP] GotFocus event

[Peter Schmitz]

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

 

[Brendan Reynolds]

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?

 

[Peter Schmitz]

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

 

[Brendan Reynolds]

Yup!

--
Brendan Reynolds (MVP)

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