What version of access are you using?
Are you certain that the Data Type is set to Date?
In my Access XP I can not use different formats in a date field even if I try.
My guess (Guess) is that the Data Type is set to text. if the only information in the field in question is a date, regardless of formatting, in the Design view if the table make the Data Type Date and choose a format and Access <b>SHOULD</b> change all the records to the same format.
No promises but I did this on my pc and it worked.
Hi Darasen but this may not work as . is not a proper date seperator (at least in access 2002) and these rows will either be blanked or deleted better to force the users to input the dates properly in the first place,
at least thats my understanding of it