Might it be 12/30/1899, which is the zero point of Access dates?
01/01/1800 doesn't ring any bells... (oh yes it does, there was that
lovely Spanish dancer at the Folies in Paris... oops...never mind...)
Check both the Table and form control Default Values properties, and
perhaps open the VBA editor and search for "1800" as a text string to
see if it's being put in from somewhere unexpected.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.