Blank Numeric Field

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.
 
V

Van T. Dinh

If IsNull(Me.TextBox1) = True Then
'TextBox1 Has Null Value

Else
...
End If

HTH
Van T. Dinh
MVP (Access)
 
Top