About Null

I have a problem with Null in VB6

If objRec.Fields(2) = Null then
    ....
    ....
    Msgbox "Success"
End If

but the message box never appears
when I debug the code, objRec.Fields(2) valued is Null.
I think it should be true
what's wrong with this ?
anyone can help ?

  Dewi
DewiAsked:
Who is Participating?
 
caraf_gCommented:
Use IsNull

If IsNull(objRec.Fields(2)) Then...
0
 
DewiAuthor Commented:
Hi caraf_g,

Thank's for your help
It's very easy, How fooled I am :)

one more question,
do you know how to create table with auto increamental field (using MSSQL) ?
http://www.experts-exchange.com/jsp/qShow.jsp?ta=mssql&qid=10318041 

  Dewi
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.