Setting Nil DateValue via RecordSet.Edit Doesn't Work

Databases
1

I have an object with a date value property.
I want to update a RecordSet.DateField with that object’s date value property.

When the object’s date value property is not Nil, the code below works fine. But when the object’s date value property is Nil, the RecordSet.DateField value will not change to Nil, instead it retains its current non-Nil value.

rs.Edit
rs.Field(“DueDate”).DateValue = Object1.DateValue
rs.Update

Why won’t a Nil Object1.DateValue assign to the recordset field?

2

Oh, and by the way, this is with an SQLite database.

3

I think you need to use .Value for assigning Nil:

rs.Edit If Object1.DateValue Is Nil Then rs.Field("DueDate").Value = Nil Else rs.Field("DueDate").DateValue = Object1.DateValue End rs.Update