Combobox null in if statement

ms-access vba ms-access-2013
D347HxD picture D347HxD · Nov 12, 2013 · Viewed 59.7k times · Source

I am trying to code an if statement where if a certain combobox is null, then it runs a certain part of code if it has data in it then it runs another. I wrote up this:

Private Sub ProjectAddSetDateAutoBtn_Click()
If ProjectAddAllDueDateAutoCmBx = Null Then
'Code1
Msgbox("ComboBox Is Null")
Else
'Code2
Msgbox("ComboBox Has Data")
End If
End Sub

I leave the combobox with no data, and then it doesn't run the code in the first part of the if or the code in the 2nd part of it either! If I enter data into the box, it runs the 2nd part of the if statement perfectly. There are no errors, I am quite stumped on this. Do ComboBoxes have their own "Null"? Is there a problem with this if statement?

Answer

HansUp picture HansUp · Nov 12, 2013

Nothing is ever equal to Null, not even another Null.

Use IsNull() to check whether the combo box is Null.

'If ProjectAddAllDueDateAutoCmBx = Null Then
If IsNull(ProjectAddAllDueDateAutoCmBx) = True Then

Related questions

ADODB doesn't exist in Access 2013 project, how do I add a reference to it

I am trying to rebuild an Access adp project in Access 2013 as and mdb. The tables are all linked tables in both version so that is not an issue. I have imported the forms from the old project so the …

Read More
On Click Error: "occurred while Microsoft Access was communicating with the OLE Server or ActiveX Control"

Seems like this is has been asked a few times before. After working on a form for a few weeks, I suddenly get the error when I click on a button: "The expression On Click you entered as the event …

Read More
Access 2013 VBA - Setting New Click Event for Controls

I have searched everywhere for this, and it seems like a simple fix, but I can't seem to find the solution. I have several Rectangle controls in my Access 2013 form, and I'm creating an OnClick event that handles them all. …

Read More