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

ID: Q90876

The information in this article applies to:

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

Last Reviewed: March 11, 1999