I have a web form that is populated using asp, by entering the ID of a record in the access database. The users can then edit the fields (inc 20 date fields).
The problem arises when a date field is left blank (many of the dates will only be known later). I get a "type mismatch" or "field cannot be a zero length string" error when I try to update.
Access doesn't have an option to allow zero length string for date/time fields and I can't convert the date data type to text with an input mask as there are calculated fields in a related query.
Any help would be appreciated.