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

ID: Q92826

The information in this article applies to:

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.


The value you entered will be displayed as "04:57 PM." 


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

Last Reviewed: March 12, 1999