Date and Time Formatting Example
Overview
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