I'm saving the contents of textboxes in 2 the recordset on the click of the Save button. If I hv a blank field in the textbox specified fr Date and I try to save it in the recordset, it givz an error. This happens even when I try 2 append a "" to it.
TrainingStartDate is a SmallDateTime field

rsEmployeeInfo!TrainingStartDate = " " & txtTSDate.Text

figured this wd work

If Trim(txtTSDate.Text) = "" Then

rsEmployeeInfo!TrainingStartDate = Null

Else

rsEmployeeInfo!TrainingStartDate = " " & txtTSDate.Text

End If


Is there any other way around it or is this OK-coz I hv 5-6 Date fields.


2.) I want 2 know frm where I can use the Date Control->I was told it wd b in the MS Windows Common Controls, but its not there