ACC2: How to Format Data in Combo Boxes and List Boxes

ID: Q120904


The information in this article applies to:


SUMMARY

Novice: Requires knowledge of the user interface on single-user computers.

Microsoft Access displays data in list boxes and combo boxes whose RowSource property is set to a table or query using the format defined in the underlying fields' Format property.

If you want the data in a list box or combo box to be displayed with a different format, you can create a query and set the fields' formats using the query's Format property, or you can use the Format() function in an expression.

If a list box or combo box's RowSource property is set to an SQL statement, a field's Format property will have no affect on how the data is displayed, because SQL statements do not contain or specify any formatting information.

NOTE: In version 7.0, combo boxes have a Format property.


MORE INFORMATION

To change the format for a field in a query, follow these steps:

  1. Select the field in the query grid.


  2. From the View menu, choose Properties.


  3. Select one of the predefined formats in the Format property box, or enter an expression to format the field.


  4. Close the property sheet.


The following are examples of expressions for formatting fields in a query:


REFERENCES

For more information about formatting data, search for "Format," and then "Formatting a Field" using the Microsoft Access Help menu.


Keywords          : kbusage FmsCmbo 
Version           : 2.0
Platform          : WINDOWS 
Issue type        : kbhowto 

Last Reviewed: April 7, 1999