Dates, empty dates - the question is how?

[amacfarl]

Trying to set a Visual FoxPro Date field to Null via DAO/ODBC results in an error.

The FoxPro ODBC driver does not use Null for an empty date. You can set the date field to 12/30/1899 instead. The Visual FoxPro ODBC driver translates this value into an empty date.

The question is what do you do with Microsoft Access? I am stuck!!!!

[googie]

In the design mode in Access if you use Date/Time as the Data Type you can set the "Required" property to no. When you add records do not put a value in the Date field and it will treat it as a Null value.

Hope this helps.