My country use Date format dd/mm/yy but default in Microsoft Access use format mm/dd/yy. I want to let user enter data format dd/mm/yy. I already changed Date format in Regional Settings in Control Panel to dd/mm/yy. When I enters Date which day more than 12, It shows correct Date (dd/mm/yy format). However, it changes to mm/dd/yy format, if I enters Date which day less than 12.
Example
I enters I want It shows
15/01/45 15 Jan 2545 15 Jan 2545
02/01/45 02 Jan 2545 01 Feb 2545
05/03/45 05 Mar 2545 03 May 2545
Thanks
Example
I enters I want It shows
15/01/45 15 Jan 2545 15 Jan 2545
02/01/45 02 Jan 2545 01 Feb 2545
05/03/45 05 Mar 2545 03 May 2545
Thanks