Null value not responding in VBA Code

[George]

Good Day All,

Can anyone help me to understand why the Null reference is not being acknowledged in the following module?

[HTML
Private Sub Errors_Click()

Dim MonthDate As String



If Me.Combo7.Column(0) = Null Then
MsgBox "Enter a MonthYear value"
End If

End Sub][/HTML]

[ranman256]

you dont check null that way, use:

if IsNull(me.combo7) then

[isladogs]

Or perhaps its an empty (zero length) string which isn't the same thing

Try this which cover nulls & ZLS:

If Nz(Me.Combo7.Column(0),"") = "" Then

but if column(0) is the bound column it can be omitted

If Nz(Me.Combo7,"") = "" Then

BTW this line isn't used in the sub so should be deleted

Dim MonthDate As String

As its in a sub, its out of scope anywhere else

[George]

Thanks. Its working now.

[ssanfu]

FYE (for your edification),

Nothing is equal to NULL, not even NULL.

In the immediate window, if you enter

? 1 = 1 , the result will be TRUE

If you enter
?Null = Null, the result is NULL

That is why there is an IsNull() function...... to check if a value is null.