I have been working for some time on a large MS Access DB with a VB6 front end, and have come across an issue that I haven't been able to resolve or work around.

My DB has many date fields that I have no problem reading or writing to, until it comes time to occasionally totally delete a date from a given record in the DB, which always gives me a format error. I've tried every possible format and still get an error.

I'm using Jet / ADO / SQL to read and write to the DB.

Aby help??

Thanks as always.

Chief Brad
Fort Worth, TX