I am trying to use the Lost Focus event to validate if a field is null or not. After I display the message box I want to set the focus back on the same field, but the code I have moves to the next field.
I have attached the code. Any assistance in pointing out what I'm doing wrong would be great.
Private Sub CustId_LostFocus()
Dim varLength As Variant
varLength = Len(CustId.Value)
If IsNull(varLength) = True Then
MsgBox ("You must enter a Cust ID.")