Enter Null into a date field

[Peter Kinross]

I have tried this every which way, but if I try to enter a Null, "", vbNullstring, Empty or vbNull into a date field I get an error. There must be a way of setting a date field so it has nothing in it in code, but it eludes me. I can delete the values manually and don't get an error.
Any ideas anyone?

[JohnH]

What happens if you just use: Me.EventDate=Null ?

Works for me.

[HansV]

In an update query, you should use Null in the Update to: row, and in VBA, you should be able to use code such as

Me.SpecialDate = Null

To make sure, I have tested both just now; they did what was expected without error.

This won't work if the date field is required of course.

[Peter Kinross]

Can't get that far.
Dim TargetDateIn As Date
TargetDateIn = Null
gives error:
Invalid use of Null

I tried using DtIn dimmed as variant, then testing if IsNull(DtIn) and if so setting the date field to Null.
It works.

[JohnH]

You are trying to set a variable to Null rather than a field.

Only variables of type Variant can be Null.

[Peter Kinross]

Thanks John. You were answering and I was editing at the same time.

[HansV]

Keep in mind that TargetDateIn is a variable, not a field.