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?

using dummy values is usually not a good idea. can you use the same approach but with a null value? i.e., instead of putting in a "meaningless value" leave it null and make NULL your "meaningless value"; instead of checking to see if the value is 00/00/0000, check to see if it is null. hth.

I agree with wazz--IMHO, you are better off with a null.

If your concern is making it stand out, and if you are in Excel, I would recommend that you use Conditional Formatting to do something like make the whole row red if the date field is null (or just that cell, if you prefer).