RE: FN-FORUM: Null testing problem

date posted 4th January 2006 01:09

Hi Andy,

That fixed it. Why, I'll never know, I just thought that for now it wouldn't
matter if it checked twice, bit it did.

So, for the record, this is what worked....

If DBRead.Item("Region")Is DBNull.Value Then
.region = ""
Else
.region = DBRead.Item("Region")
End If

Thanks,

Craig
-----Original Message-----

First do the test for is null;

IF DBRead.item("Region") is null then
'blah
.region=""
Else
.region = dbread.item("region")
End if

You don't need to check to see if it's ""