[ASAP] GotFocus event

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Peter Schmitz - 01 Mar 2005 20:25 GMT

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

Reply to this Message

Brendan Reynolds - 01 Mar 2005 20:37 GMT

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?

Signature

Brendan Reynolds (MVP)

> Hi,
>
[quoted text clipped - 13 lines]
> Thanks
> Peter

Reply to this Message

Peter Schmitz - 01 Mar 2005 20:51 GMT

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

> 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 ...
[quoted text clipped - 31 lines]
> > Thanks
> > Peter

Reply to this Message

Brendan Reynolds - 02 Mar 2005 11:27 GMT

Yup! :-)

Signature

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
[quoted text clipped - 40 lines]
>> > Thanks
>> > Peter

Reply to this Message