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