Resetting an Access Date to Null

[Slarti]

I'm using DAO to connect to an Access database and having trouble emptying a Date/Time field in my table. To begin with the field is empty and that's OK, when I enter a date that too is saved, my problems begin when I try to remove the Date. I've tried restting to Null, vbNull and vbNullChar. Each time I hit an error or the date is reset to 31/12/1899.

 

[SkipVought]

Hi,

Take a look at the Required Property for the date field. IF it's True, you can ONLY have a valid date in that field.

Skip,

Want to get great answers to your Tek-Tips questions? Have a look at faq222-2244

 

[Slarti]

Thanks Skip. I'm out of the office for a day or two but will try this on Friday.

Slarti.

 

[Slarti]

Skip, This doesn't mke a difference. I'm using Access '97 is that why? Slarti.

 

[bjd4jc]

Using an SQL Statement this is how you accomplish this:

UPDATE TableName
SET DateField=NULL
WHERE ...

 

[Slarti]

Thanks bjd4c. I'll take a look tomorrow in work. Slarti.

 

[Slarti]

Superb, thanks bjd4c.