Blank Numeric Field

  • Thread starter Thread starter Mark S
  • Start date Start date
M

Mark S

If a text box on a form has the control source of a numeric field from
a table, how do you test in code to see if the field is blank? IF
LBL1 = NULL... and IF LBL1 = ""... return errors. I have a workaround
of IF LEN(LBL1 & "a") = 1 THEN ... but that is just terrible coding.
 
If IsNull(Me.TextBox1) = True Then
'TextBox1 Has Null Value

Else
...
End If

HTH
Van T. Dinh
MVP (Access)
 
Back
Top