Date Displaying Incorrectly - numbers added.

[Romuba]

I have recently started learning to use Access and all is going very well except for the date. As can be seen from the images below I have set up my date function correctly in Control Panel and everywhere I use a date it is displayed correctly. In Access however numbers are added which I cannot figure where they are coming from and don't want them there. In the second image you can see what the various Format options look like. When long format is used in a Form or Report it displays those additional figure. I cannot get 2015 to display but get 15316 or similar instead.



Please assist if you know this issue and solution.

[orange]

I don't know your specific issue, and have not seen it before. But here is a link with info re dates that might be helpful to you. You may have some degree of corruption???

Good luck.

[Romuba]

Thank you but I understand the various formatting options but I have info displaying that makes no sense.