Jerry's answer is correct, but to give you some additional info.
the Input Mask property has no effect on how data is stored in a field or
how it id displated. It is only used during data entry to assist a user in
entering a value correctly.
Also, if you are using Now() to populate the field, but you really only care
about the date, you should be using Date(). That is because any comparisons
you use on a date field that has times in it will likely be wrong if you
don't also include the time down to the second.
Note that all date fields do contain a time component, but the Date function
always returns midnight - 08/2702009 00:00:00 AM But, if you use Now, it
will include the time - 8/27/2008 4:00:39 PM
So, if you are looking for records for a date, say today's date:
SELECT * FROM SomeTable WHERE [MyDateField] = Date();
8/27/2008 4:00:39 PM not be included.
Dave Hargis, Microsoft Access MVP