If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Blank Numeric Field
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. |
#2
|
|||
|
|||
Blank Numeric Field
If IsNull(Me.TextBox1) = True Then
'TextBox1 Has Null Value Else ... End If HTH Van T. Dinh MVP (Access) -----Original Message----- 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. . |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Suppressing a blank field in a report | Kay | Setting Up & Running Reports | 4 | July 14th, 2004 05:08 PM |
'This page left blank' field does not work on Roman numbers etc. | Craig Flores | General Discussion | 3 | June 8th, 2004 12:31 AM |
Please help! Displaying only rows with empty cells in a numeric field using Advanced Filter. Thanks | JOCA | New Users | 1 | June 5th, 2004 02:37 AM |
Suppressing a Blank Field | Kim Cose | Mailmerge | 1 | May 11th, 2004 09:36 PM |