MS Access Date Format

3 Likes Comment

You may format a Date/Time data type using one of several different types of date or time styles in Microsoft Access. For example, there is a format for a short date: 8/1/2001; or a long date: Saturday, August 11, 2001.
STEPS
1. In Table Design view, click in the Date/Time field to be formatted.
2. Press F6 to move to the FIELD PROPERTIES box. Or, click in the FORMAT line in the FIELD PROPERTIES area.
3. Click the down arrow in the FORMAT box.
4. Select the desired format.
5. Press F6 to return to the field.

You might like

About the Author:

Leave a Reply

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