invalid use of null

<vbcode>
If rstCurrent("City") = "" Then
txtCity = ""
Else
txtCity = rstCurrent("City")
End If
</vbcode>

rstCurrent is a recordset, txtCity is a textbox. The code above generates "Invalid use of null". How can I check if rstCurrent("City") is indeed Null?

thanks a lot

Try this:

If IsNull(rstCurrent("City")) then
txtCity = "null"
ElseIf rstCurrent("City") = "" then
txtCity = ""
else
txtCity = rstCurrent("City")
End If




Crazy D :-)
"One ring rules them all"