Hi andy

for question 2, i mean the value in the date time picker always shown in the text box, it not allow me to delete the date or make it blank. For...

hi veteran,

ya the date field have the problem, i have change it.......

Thanks..

*0*

Thanks veteran,

i added your code and it work well

The following code is for the field allow zero length is ms access table's field

tbl.Columns.Append("VesselName", ADOX.DataTypeEnum.adVarWChar, 50)

tbl.Columns.Append("ApproveDate", ADOX.DataTypeEnum.adDate)

tbl.Columns.Item("ApproveDate").Properties("Jet OLEDB:Allow Zero Length").Value...