Max, thanks for the reply, and I understand not being able to Len(Null).
I actually tried a different approach, and it seems to have cleared it up. But it doesn't explain your Len(Null) theory.
I originally had
Code:
If Len(txtJobNumber) = 0 Then
MsgBox ("You have not provided a Job Number!" & vbCrLf & vbCrLf & "You cannot add a new record without this value.")
Exit Sub
End If
which didn't work to find a blank text box. So I fiddled around with the logic and came up with:
Code:
If Len(txtJobNumber) > 0 Then
Else
MsgBox ("You have not provided a Job Number!" & vbCrLf & vbCrLf & "You cannot add a new record without this value.")
Exit Sub
End If
And it finds a blank txtJobNumber control every time! It's weird I know. Is there any explaination to a Len()=0 of blank textbox control not resolving to true?