Dear Guys,

I have been developing a wpf application with a MS Access .mdb database. The pain window includes a range of textboxes from large data table, with 3 child tables to the main table, all as datagrids on the main window. I have had difficulties with the textboxes accepting null values, and this has been resolved for text formats by specifying acceptance of null values within the Access database. However, Access only allows this setting for text fields, not date fields.

When I try to enter date values or changes in date fields (currently all datepickers), I cannot update the field using update functions, with a null exception thrown. I can work around this by placing the field in edit mode by double clocking or F2, and then exiting by tab once the data are added. However, this is clumsy. Does anyone have any thoughts on how this might be done more elegantly. eg is there code to emulate F2? I cant find it anywhere?

Thanks again.