IsDBNull

[Goldfinger]

I have some code that checks for a null value

If IsDBNull(Rec1.Fields("new_address2")) = true Then

End If

Everytime this code is reached, even if it is null, it will never step into the If statement. I have tried to look at all the examples on this site but nothing talks about pulling null values from databases and checking them. Thanks

[nemaroller]

A zero-length string does not equate to DBNull.

Check the example code given at MSDN:

http://msdn.microsoft.com/library/de...afctIsNull.asp

Anyway...
you either have to test for it on the SQL server, or test for it in the VB code...

Testing on the client-side:

If Rec1.Fields("new_address2") = String.Empty  Then

Testing on the DB-side:

new_Address2 varchar(50)= null

If Rec1.Fields("new_address2") Is DbNull.Value Then

[Goldfinger]

I looked at that page and I still have issues. When I step through the code the value of Rec1.Fields("original_address2").Value is {System.DBNull}. How do I do this?

[pvbangera]

i think u are missing 'Value' keyword in ur code.

If IsDBNull(Rec1.Fields("new_address2")[B].Value[/B]) = True Then
 
End If