Null values in tables and VBA

  • Thread starter Ingvar engelbrecht
  • Start date
I

Ingvar engelbrecht

How do I test for the precense of a Null value when
retrieving a field in VBA with a statement like:
var = rst("VariableName"). The field is Null but a test
like:
If rst("VariableName") = Null then
end if

does not work
 

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

Updateing a record with a Null value field, fails? 5
Return 0 when value is Null 1
Are there functions/Or Events that are called automatically whenthe database file first opens and Wh 2
Write to a specific Record in a table 3
Invalid Use of Null 3
Remvoving Null Items from an ADO Recordset prior to sending to Exc 3
VBA in Access 2
Set value for function through form code 3

Top