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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Module for all Identical Forms 7
Field is not getting value in Access 2007 5
Link a text box based on drop down box with four options MS Word 365 0
Matching literal text "???" in Word 2010 field code IF statement 2
DMax on existing record to increment serialized # fails 1
Display all cells values of that row from where a cell value retri 5
Adding data to MS Access from csv file 0
Display required succeeding cells value if a cell value A1 is capt 16

Top