Make your own free website on



Date and Time Formatting Example


In the Form frmDateFormatExamples, there are two columns -- one shows using a format, named or constructed, in the Format property of a Text Box; the other shows using the same format in an expression to create the string representation. (Note that the strings would default to left-justified, and to make them more easily comparable, right-justification was manually selected.) There are a few differences between the two columns, and these have been reported to Microsoft. All of the differences can be avoided by using a slightly different method of formatting the date and time, so I would not expect these to be high priority items for Microsoft.

File Format

This ZIP file includes A2003DateTestingDB.mdb in Access 2002/2003 file format.

Access 2003 Date and Time Formatting Example


This site was last updated 07/11/07