ListDisplayField Property

                  Applies To

Returns or sets the field that is displayed in the list or combo box (as opposed to the field that is bound). There can be only one displayed field. This property applies only to list boxes and combo boxes. Read/write String.

Remarks

Use the ListBoundField property to return or set the bound field.

This property is used with the ListRowSource property and the ListBoundField property to control how data is displayed in a list box or combo box. For example, consider a list box which displays product names in a section called Order Details. The recordset behind the Order Details section includes a field named ProductID which is the product for a given Order Detail record. But instead of displaying ProductID in a textbox, the page author wants to display product names in a dropdown list box. The list box can be filled with a recordset definition named Products which contains fields called ProdID and ProductName from the Product table. The properties of this list box element would be set as shown in the following table.

Property Value
ListRowSource Products
ListBoundField Prod ID
ListDisplayField Product Name
ControlSource Product ID