I, by no means, am proficient in Access. However, my probem is that in an event tracking spreadsheet, I have a field designated as "End Date". The data type is set at Date/Time. Usually, I have valid dates to populate the data, however; there are certain dates that need more generic dates. What I mean is, cells where a date or value is needed to be entered, but the date is currently unknown (right now I have entered "1/1/1900", but that does not stand out enough)....this is where I would like to enter in either text or, preferrably "0/00/0000". Ideally, I would like to enter in the date "0/00/0000". Is there any way to do that?