ACC: How to Display List/Combo Boxes with More Than One Field

ID: Q90876

The information in this article applies to:

Microsoft Access versions 1.0, 1.1, 2.0, 7.0

SUMMARY

Moderate: Requires basic macro, coding, and interoperability skills.

This article discusses how to display more than one field in a list box or combo box.

MORE INFORMATION

If you enter an SQL command in the RowSource property for the control, Microsoft Access can display more than one field in a list box or combo box. For example, if you want to combine two fields into one list box, the syntax for the SQL command could be as follows:


   Select [FieldName1] & [FieldName2] from [TableName];

If you are using a bound column in the list, the bound column would now apply to the placeholder in the SQL statement. In the above example, a bound column setting of 2 would equate to FieldName2.

Additional query words: listbox combobox row source

Keywords : kbusage FmsCmbo
Version : 1.0 1.10 2.0 7.0
Platform : WINDOWS
Issue type : kbhowto