Microsoft KB Archive/92826

{|
 * width="100%"|

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

 * }

Q92826

-

The information in this article applies to:


 * 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 &quot;h:mm am/pm&quot;.

STATUS
This behavior no longer occurs in Microsoft Access version 2.0.

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 &quot;04:57 PM.&quot;

Keywords : kbusage

Issue type : kbprb

Technology :