Focus
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?
|