Microsoft KB Archive/90876

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

Article ID: 90876

Article Last Modified on 5/9/2003

-

APPLIES TO


 * Microsoft Access 1.0 Standard Edition
 * Microsoft Access 1.1 Standard Edition
 * Microsoft Access 2.0 Standard Edition
 * Microsoft Access 95 Standard Edition

-



This article was previously published under Q90876



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



SUMMARY
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: kbhowto kbusage KB90876

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.