I have a textbox for putting in Employee ID. The moment I enter the
employee ID and tab out of the control, there is a validation being
done. If it is an invalid ID, I get the message box but the curor moves
to the next control. How can I take it back?

If Len(aEmpID.Value) < 5 Or Not IsNumeric(aEmpID.Value) Or check =
False Then
MsgBox "Incorrect Employee ID"
aEmpID = Empty
aEmpID.SetFocus
End If

SetFocus is not working for me. Is there any other syntax?

Assuming that this code is in an Exit event procedu

Cancel = True ''replace aEmpID.SetFocus with this

Regards,
Steve
www.stkomp.com

wrote:
I have a textbox for putting in Employee ID. The moment I enter the
employee ID and tab out of the control, there is a validation being
done. If it is an invalid ID, I get the message box but the curor moves
to the next control. How can I take it back?

If Len(aEmpID.Value) < 5 Or Not IsNumeric(aEmpID.Value) Or check =
False Then
MsgBox "Incorrect Employee ID"
aEmpID = Empty
aEmpID.SetFocus
End If

SetFocus is not working for me. Is there any other syntax?

I had it in the AfterUpdate event but now I have changed it to Exit
even and your Cancel=True is working fine

Thank you


wrote:
Assuming that this code is in an Exit event procedu

Cancel = True ''replace aEmpID.SetFocus with this

Regards,
Steve
www.stkomp.com

wrote:
I have a textbox for putting in Employee ID. The moment I enter the
employee ID and tab out of the control, there is a validation being
done. If it is an invalid ID, I get the message box but the curor moves
to the next control. How can I take it back?

If Len(aEmpID.Value) < 5 Or Not IsNumeric(aEmpID.Value) Or check =
False Then
MsgBox "Incorrect Employee ID"
aEmpID = Empty
aEmpID.SetFocus
End If

SetFocus is not working for me. Is there any other syntax?