Zero Length Date Fields in Databases

[Mike Goodman]

Can any one tell me how to save 'Nothing' to a Date field in a recordset.
Senario;
A date has been saved to a Date Field, thus changing the field from Null. The date is then not needed and deleted from the corresponding textbox object bound to the field. If I leave the textbox empty I get Data Conversion Error.
Surely there must be a way? . . .


[This message has been edited by Mike Goodman (edited 09-28-1999).]

[Jamppa]

You told that you try to update "nothing" into the field.
if your program corverts an empty textbox into value "" that cant be updated into the datetime field.

You can insert or update value Null into a datetime field.

recards Jamppa