How to reference an empty combobox

[cp2599]

My combobox is empty, but my code is not picking that up. I've tried
the following statements and none seem to work. Any suggestions?

If Nz(Me.cboSearchArea,0) = 0 then If Nz
(Me.cboSearchArea.Value, 0) = 0 then

If Me.cboSearchArea = "" then If Me.cboSearchArea.Value
= "" then

If Me.cboSearchArea = 0 then If Me.cboSearchArea.Value
= 0 then

If Me.cboSearchArea = " " then If Me.cboSearchArea.Value
= " " then

I'm having the same problem with a numeric field as well.

 

[Arvin Meyer MVP]

How about:

If Len(Me.cboSearchArea & vbNullString) = 0 Then

That checks the length of the data in combo, whether Null or Empty, and if
it = zero, then ...

 

[Jeanette Cunningham]

Where are you putting this code?
If you are using the before update event of the combo, you will need to use
its text property.

If Len(Me.cboSearchArea.Text) = 0 Then
'code
Else
'other code
End If


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[cp2599]

Where are you putting this code?
If you are using the before update event of the combo, you will need to use
its text property.

If Len(Me.cboSearchArea.Text) = 0 Then
    'code
Else
    'other code
End If

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia











- Show quoted text -

Thank you Jeanette. I moved my code into the cmd button and it works.

 

[cp2599]

How about:

If Len(Me.cboSearchArea & vbNullString) = 0 Then

That checks the length of the data in combo, whether Null or Empty, and if
it = zero, then ...
--
Arvin Meyer, MCP, MVPhttp://www.datastrat.comhttp://www.mvps.org/accesshttp://www.accessmvp.com











- Show quoted text -

Thank you Arvin. I will hang onto this code for another time. I was
referencing other combo boxes that didn't have focus so I moved the
code to the command button and it worked.

 

[Arvin Meyer MVP]

How about:

If Len(Me.cboSearchArea & vbNullString) = 0 Then

That checks the length of the data in combo, whether Null or Empty, and if
it = zero, then ...
--
Arvin Meyer, MCP,
MVPhttp://www.datastrat.comhttp://www.mvps.org/accesshttp://www.accessmvp.com

<[email protected]> wrote in message

Thank you Arvin. I will hang onto this code for another time. I was
referencing other combo boxes that didn't have focus so I moved the
code to the command button and it worked.