SetFocus method in VBA
 

I'm trying to do some data validation during
the 'LostFocus' event of a textbox. If the validation
test fails, I want to return the user to the textbox.

I'm trying 'txtAmount.SetFocus' which I found in the MSDN,
but I'm getting an error that the method is not supported
by the object. Has SetFocus method been removed from
Office XP? If not, what's the syntax and how can I make
it work?

Robin

SetFocus method in VBA
 

Setfocus is still supported; I'm using it in my own projects (Access).

If I find out possible reason(s) why the method may not work, I'll post so
later.

Randall Arnold

"Robin S." wrote in message
...
I'm trying to do some data validation during
the 'LostFocus' event of a textbox. If the validation
test fails, I want to return the user to the textbox.

I'm trying 'txtAmount.SetFocus' which I found in the MSDN,
but I'm getting an error that the method is not supported
by the object. Has SetFocus method been removed from
Office XP? If not, what's the syntax and how can I make
it work?

Robin

SetFocus method in VBA
 

Robin:

It looks like the Textbox used with MSForms does not support Setfocus (or
Gotfocus either). However, the Control object (from the Controls
collection) does. I suspect that can be used to enumerate the particular
textbox you want and use its Setfocus method. In fact, the more I think
about it, I believe I've seen this referenced somewhere...

Randall Arnold

"Randall Arnold" wrote in message
...
Setfocus is still supported; I'm using it in my own projects (Access).

If I find out possible reason(s) why the method may not work, I'll post so
later.

Randall Arnold

"Robin S." wrote in message
...
I'm trying to do some data validation during
the 'LostFocus' event of a textbox. If the validation
test fails, I want to return the user to the textbox.

I'm trying 'txtAmount.SetFocus' which I found in the MSDN,
but I'm getting an error that the method is not supported
by the object. Has SetFocus method been removed from
Office XP? If not, what's the syntax and how can I make
it work?

Robin