Using VBA in Access 2000, how do you set a date field of a table .

[Thos]

Using VBA in Access 2000, how do you set a date field of a table to a blank
value. Thus, when viewing the field contents, you would see nothing.

 

[Ken Snell [MVP]]

Set the value to Null.

 

[Arvin Meyer]

Try removing the default value of 0.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access