SET focus back to TEXTBOX if validation does NOT pass

[taimysho0]

hello, i have a textbox with a validation in the "lost focus" property. if the text the user inputs in the textbox is incorrect, it clears out the textbox. but, for some reason after the validation message box appears for the user, the cursor moves to the next textbox. how do i get the cursor to go back to the original textbox with the validation? thanks

basically, until the user enters a correct string, the cursor will not move to the next textbox. thanks!

[GrandMasterSexay]

sendkeys "+{TAB}"

[taimysho0]

sorry im not too familliar with vb code, so i can put that in the "lost focus" attribute of my textbox and it will bring the cursor back to the original textbox? for example

if isnull(me.txtbox) then
msgbox ("incorrect username")
sendkeys "+{TAB}"

[GrandMasterSexay]

i usually use sendkeys when the cursor does not get back to a specified textbox
If text1.setfocus does not work, you can try sendkeys.

In your case,if the below code does not work, try Option 2

Option1:

if isnull(me.txtbox) then
msgbox ("incorrect username")
text1.setfocus
endif

Option2:
if isnull(me.txtbox) then
msgbox ("incorrect username")
sendkeys "+{TAB}"
endif

[nicknameoscar]

If your validation consists of making sure your textbox is not null (as your comments above would indicate) then perhaps you could use the On Exit event instead of the On Lost Focus event. The On Exit event allows you to Cancel the event.

If isnull(me.txtbox) Then
MsgBox ("incorrect username")
Cancel = True
End If

If you are using some other form of validation and you have a situation where you 'might' want to tab past this particular textbox then the below might be necessary:

If (your validation condition here) = False Then
MsgBox ("incorrect username")
Cancel = True
Else If IsNull(Me.YourTextBox) Then
Cancel = False
End If

I did not test the above. Just thinking out loud.

[RuralGuy]

Validation is usually done in the BeforeUpdate event of a control and Cancel = True set to hold the focus in the control. The Exit event is useful as someone already stated, to catch people skipping by a control.