blank dates?

[davidoc]

Hi,

I having a bit of trouble with my date fields in a table. I want the user to be able to change a date to either another date or blank through a form interface. Access won't allow me take a blank string from a text box and put it into a date field in the table.
anyone got any ideas

thanks
Dave

 

[Ally]

I think you need to change the default value in your original table design to Null. That way it shouldn't throw up an error when deleted.

 

[davidoc]

I had hoped I wouldn't have to resort to that