Insert a empty datetime field

[Datahighway]

HI ALL,

how can i insert a empty datetime field in a Access 2000 database.

I know , if the textbox empty so must i write a dbnull in the database.
But how can i do this ?
Can anyone help me ?
Regards Datahighway

 

[a_jam_sandwich]

Use SQL like this

INSERT INTO MyTABLE (MyDATE) VALUES (NULL)

All you do as above is enter NULL as the value in the SQL

Regards

Andy