tech on the net
Home About Us Feedback Site Map


Access Excel Word


SQL Oracle / PLSQL SQL Server MySQL MariaDB PostgreSQL

Web Development

HTML CSS Color Picker


C Language


ASCII Table Linux UNIX Java Clipart Joke of the Moment
Share this page:

MS Access: Define a custom format for a Date/Time field in a table in Access 2007

See solution in other versions of Access:

Question: In Microsoft Access 2007, I have a table with a date field in it. When I view the table, I'd like to see the date value displayed as "mm/dd/yyyy hh:nn:ss" format. How can I do this?

Answer: In Access, you can use the Format property to customize how a date will appear in a table.

To create a custom date format on a field, open your table in Design view by right-clicking on the table name in the left window and selecting Design View from the popup menu.

Microsoft Access

Then select the date field, and set the Format property that you'd like to appear in the field. For example, if you wanted to view the date as "01/31/2005 21:00:00", set the Format property to:

mm/dd/yyyy hh:nn:ss

In this example, we've set the Format property for the OrderDate field.

Microsoft Access

If you wanted to view the date as "01/31/2005 9:00:00 PM", you would set the Format property as follows:

mm/dd/yyyy hh:nn:ss AM/PM

Microsoft Access