Defining date format in MS Access Field

This article will describe how Microsoft Office Access stores the information regarding date and time and how you can add a time and date fields to your forms, tables, and reports and how you can customize date and time format that suit your needs. To use the dates and times inside a database, you have to start by creating a Time / Date field in one or more than one of your database tables. The settings for time or date fields always resides within a table but date or time value can displayed within a form, table, or report.

To define a Date format you have to go through the following steps:

Step 1 – First of all you need to go to the Navigation Pane and then right-click on the table for which you want to work and then click Design View.

Step 2 – In upper section of table designer you have to select a blank row then in Field Name column, you have to type a name for new field.

Step 3 – After that in Data Type column select the Date/Time from list and then save the table. The new field will resemble to this one, although field name may vary and that may be a query designer with a new Time/Date field. So you can also store time and date values as numbers when you are going to plan perform calculations on date and time data.

Step 4 – For the further customization again you have to go through the Navigation Pane and then right-click on the table, you want to work with and then click the Design View.

Step 5 – Further you will find the Date/Time field in upper section of design grid and you have to select it and can make alterations with your desired format.

Step 6 – In lower section, click on Format property box and then enter format. After entering the format, the Property Update Options i.e. the smart tag property update and smart tag appears and lets you to apply format to any other form controls and table fields that would logically inherit it.

Step 7 – Next to apply the changes you made throughout the database, you have to click on the smart tag and then Update Format everywhere Field Name is being used. In this particular case the Field Name is the name of Date/Time field. Now if you choose to apply changes to your entire database then the Update Properties dialog box will appear and display forms and other objects that inherit the new format.

Step 8 – Click Yes to apply format and save your changes and then switch to your Datasheet view to see whether format meets your needs or not.

Step 9 – Change Windows regional settings to the view of dates and times that are displayed in your system. The Windows operating system supports a variety of languages, plus date/time formats for different countries and regions.

That’s all what you need to customize and define a Date format within a Microsoft Access Field.

Leave a Reply

Your email address will not be published. Required fields are marked *