"invalid use of null" error. Makes no sense

[tahoer111]

If rstTable.Fields(2) = Null Then
strDescription = " "
Else
strDescription = rstTable.Fields(2)
'"Invalid use of null" error occurs right here. How can this be?
End If

[nishantp]

Try replacing Null with vbNullString.

[Ken Bradford]

replace

If rstTable.Fields(2) = Null Then

with

if isnull(rstTable.Fields(2) then


and

strDescription = rstTable.Fields(2)

with

strDescription = rstTable.Fields(2) & ""

[jcfowl]

I had a problem like this also. If you are dealing with SQL
the definition for Null does not work with VB's Definition.
If none of the previous suggestions work declare a Variable
of Type Varient. Put the database value in the variable and
then do your IF statement. That should do it.

[Alain]

You can use:

If blahblah = Null

Use If IsNull(blahblah) = true then
 'you got your null
else
 'value is correct
end if

[Alain]

I meant:

"You can't use:"

[WALDO]

In ASP (VBScript), that won't work. Believe me, I've hit this wall before.

Try This:

If Len(rstTable.Fields(2).Value & "") = 0 Then
    strDescription = ""
Else
    strDescription = rstTable.Fields(2).Value
End If

[Mc Brain]

Just:

strDescription = "" & rstTable.Fields(2)

No care about if it's null or not.