Setting an Access Date Type field to Null in VB

[Timinator]

I'm trying to clear out a date type field in access through a Visual Basic interface. Its not really working. I've tried setting it to NULL, 0, "" and it won't take any of them. 0 is the closest to working, but it sets the date to 12/31/99, which is no good.

Any Ideas?

Thanks.

Tim

 

[cdidion]

Change the date field in the Access database so that it can accept NULL values. Then you can do it. -Chris Didion
Matrix Automation, MCP

 

[Timinator]

I don't see a option to accept Nulls for Date Type fields, maybe i am mistaken though.

Tim

 

[cdidion]

Sorry, in Access you set it by setting the requires property of the field.

Set the required property of your date field to No.

That should do it. -Chris Didion
Matrix Automation, MCP