---
title: "In MS Access, the long and short date option does not show 4 digit years. How do I achieve the mm/dd/yyyy format?"  
description: "In MS Access, the long and short date option does not show 4 digit years. How do I achieve the mm/dd/yyyy format?"  
author: "Anonymous User"  
published: 2011-05-20  
updated: 2020-09-17  
canonical: https://www.mindstick.com/interview/975/in-ms-access-the-long-and-short-date-option-does-not-show-4-digit-years-how-do-i-achieve-the-mm-dd-yyyy-format  
category: "ms access"  
tags: ["ms access"]  
reading_time: 1 minute  

---

# In MS Access, the long and short date option does not show 4 digit years. How do I achieve the mm/dd/yyyy format?

In the date field properties of the table, form, or properties manually input the format you would like. It is not required to choose one of the date formats in the drop down box. Example would be mm/dd/yyyy.

## Answers

### Answer by Anonymous User

In the date field properties of the table, form, or properties manually input the format you would like. It is not required to choose one of the date formats in the drop down box. Example would be mm/dd/yyyy.


---

Original Source: https://www.mindstick.com/interview/975/in-ms-access-the-long-and-short-date-option-does-not-show-4-digit-years-how-do-i-achieve-the-mm-dd-yyyy-format

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.