Checking for Null Database Values

  • Thread starter Thread starter Vayse
  • Start date Start date
V

Vayse

i want to check if the following field is null.

Dim rsAssets As New ADODB.Recordset

rsAssets.Fields("SubIcon").Value)

IsNull is no longer supported, so what should I use?

Thanks

Vayse
 
Vayse said:
i want to check if the following field is null.

Dim rsAssets As New ADODB.Recordset

rsAssets.Fields("SubIcon").Value)

IsNull is no longer supported, so what should I use?

Thanks

Vayse
Click to expand...

Try IsDbNull().
 
Not quite. Convert.DBNull is a constant representing "database null" while Convert.IsDBNull() is the test for it.
 
Al Reid said:
Not quite. Convert.DBNull is a constant representing "database null"
while Convert.IsDBNull() is the test for it.
Click to expand...

However, you could use 'If ... Is DBNull.Value Then...' instead of
'IsDBNull'.
 
if rsAssets.Fields("SubIcon") = convert.dbnull then

end if
Al Reid said:
Not quite. Convert.DBNull is a constant representing "database null"
Click to expand...
while Convert.IsDBNull() is the test for it.
 
Thanks Herfried,

That was what I meant.

Herfried K. Wagner said:
However, you could use 'If ... Is DBNull.Value Then...' instead of
'IsDBNull'.
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Reading databound value 6
Checking for Nulls 2
Check for Updates not Working 1
setting a class property to a null value... 8
Help using Dlookup to find null value 2
recognizing NULL field in IF statement 2
Updateing a record with a Null value field, fails? 5
Access Building a IIF expression in Access 0

Back
Top