Insert Null value in ADO Recordset

Question

Is it possible to insert a null value into a field using the AddNew method of an ADO Recordset in VB6? In a typcial INSERT query, you would simply use NULL; however, I've discovered that this doesn't work through ADO; it inserts "NULL" instead.

Is there another way to insert a null value when adding a new record?

Answer 1

Does leaving the value blank work? Can you use dbnull.value?