ACC1x: MS Access Short and Medium Time Formats Have Leading Zero

• Microsoft Access versions 1.0, 1.1

SYMPTOMS

When you use the Short Time and Medium Time Date/Time formats, a leading zero appears in your data.

RESOLUTION

To eliminate the leading zero, use a custom format, such as "h:mm am/pm".

STATUS

This behavior no longer occurs in Microsoft Access version 2.0.

MORE INFORMATION

Steps to Reproduce Behavior

1. Create a Date/Time field.



2. Format it as Medium Time.



3. Type 4:57pm.



4. Press TAB to leave the field.

Keywords : kbusage GnlFrmt
Version : 1.0 1.1
Platform : WINDOWS
Issue type : kbprb