Microsoft Access always takes dates in the form of MM/DD/YY, where as if I need to enter 1st september like 9/1/01 it picks it up as 9th January. Actually I want users to enter dates in DD/MM/YY format, because users in this part of the world are used to the DD/MM/YY method.<BR><BR>So how do i achieve that user enter in DD/MM/YY format and access accepts as DD/MM/YY format only.<BR><BR>There are certain cases when the access smartly recognises the dates like if i enter 19/3/01 then it accepts as 19th March<BR><BR>Please guide<BR><BR>J