I have a TxtBox with a number in it. I want to have a validation. If blank a message comes up, if it is not a numeric number a message comes up. The first If statement works, but not the IsNumeric!
2014-151566
This is my coding. What am I doing wrong?
If Me.TxtCaseNumber.Value = "" Then
MsgBox "This field must be field in with a numeric #", vbCritical
Exit Sub
End If
If IsNumeric(Me.TxtCaseNumber & "e-0".Value) = False Then
MsgBox "Please enter a Numeric Number", vbCritical
Exit Sub
End If
2014-151566
This is my coding. What am I doing wrong?
If Me.TxtCaseNumber.Value = "" Then
MsgBox "This field must be field in with a numeric #", vbCritical
Exit Sub
End If
If IsNumeric(Me.TxtCaseNumber & "e-0".Value) = False Then
MsgBox "Please enter a Numeric Number", vbCritical
Exit Sub
End If