How to Define a Date Format for a Field in Access 2003
Microsoft Access 2003 is a great tool for database management. One of its many options is to define how you want your dates and times to appear in a Microsoft Access field. The format affects how the information will be viewed or printed, but does not change how it is stored. Here's how to define a date format for a field in Access 2003.
Other People Are Reading
Instructions
-
-
1
Open the Access 2003 program by clicking on its icon on your desktop.
-
2
Open the table that you'd like to modify in Design View.
-
-
3
Create a Date/Time data type field, or click on one that is already created.
-
4
In the Field Properties box in the bottom of the screen, click on the General tab and then on "Format."
-
5
When you click on "Format," an arrow will appear on the right side. Click on the arrow to obtain a menu of format choices.
-
6
Select from General Date, Long Date, Short Date, General Time, Long Time or Short Time. Use the Help icon if you are unsure which choice is the best for your needs.
-
7
Save your table before exiting the program.
-
1
Tips & Warnings
Formats for any data types will be displayed according to the country selected in your regional settings (from the Regional Settings control panel on a Windows computer or the Map control panel on a Macintosh).
You can customize your date and time formats by using custom symbols. To obtain a list of custom symbols, press the F1 key while your cursor is in the Format field.
