Microsoft KB Archive/94175

{|
 * width="100%"|

ACC1x: Date/Time Format Not Reflected in List/Combo Box (1.x)

 * }

Q94175

-

The information in this article applies to:


 * Microsoft Access versions 1.0, 1.1

-

SYMPTOMS
A list or combo box based on a Date/Time field does not display the Date or Time format assigned to the underlying field. This is particularly noticeable in a list or combo box control on a form.

CAUSE
Microsoft Access does not have a Format property for list or combo boxes even though the underlying table field has a defined Format property.

RESOLUTION
Use the Format function in an expression in a query to format the data. Then base the list or combo box on the query field instead of the underlying table field.

For example, define a query named QueryTest. Then instead of entering the name of the underlying Time/Date field (Event Date) as the field on the QBE grid, enter this expression:

  Event Day: Format([event date],&quot;mmmm d&quot;&quot;, &quot;&quot;yyyy&quot;)

Base the list or combo box on this query field to display Event Date with the desired format.

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

Steps to Reproduce Behavior
  Create a new table with the following fields:

     Field Name         Data Type Event ID          Counter Event Date        Date/Time  Set the Event Date field's Format property to &quot;mmm d, yyy&quot; (without the quotation marks). Save the table as Events. View the table in Datasheet view and enter &quot;8/11/92&quot; (without quotation marks) in the Event Date field. Add a few more records with any valid dates. Note that the dates are displayed correctly.  Create a new form based on the Events table. Add the following list box to the form:

     Object: List Box Control Name:   Event ID      Control Source:  Event ID      Row Source Type: Table/Query Row Source:     Events Column Count:   2 Column Heads:   Yes Column Widths:  0;1 Bound Column:   1  View the form in Form view. Note that the underlying field's Format property is ignored.

Additional query words: controls expressions

Keywords : kbusage

Issue type : kbprb

Technology :