ACC: How to Display List Boxes or Combo Boxes with More Than One Field (90876)


The information in this article applies to:

  • Microsoft Access 1.0
  • Microsoft Access 1.1
  • Microsoft Access 2.0
  • Microsoft Access for Windows 95 7.0
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.
Modification Type:MajorLast Reviewed:5/9/2003
Keywords:kbhowto kbusage KB90876
©2002 Microsoft Corporation. All rights reserved.