Chart Control, Combo Box Control, List Box Control, Table Fields, Unbound Object Frame Control.
You can use the ColumnHeads property to display a single row of column headings for list boxes, combo boxes, and OLE objects that accept column headings. You can also use this property to create a label for each entry in a chart. What is actually displayed as the first-row column heading depends on the object’s RowSourceType property.
The ColumnHeads property has the following settings.
| Setting | Description | Visual Basic |
| Yes | Column headings are enabled and either field captions, field names, or the first row of data items are used as column headings or graph labels. | True (-1) |
| No | (Default) Column headings are not enabled. | False (0) |
You can set the ColumnHeads property in the control’s property sheet, a macro, or Visual Basic.
For table fields, you can set this property in table Design view for fields with the DisplayControl property set to Combo Box or List Box.
Note Microsoft Access sets this property automatically when you select Lookup Wizard as the data type for a field in table Design view.
The RowSourceType property specifies whether field names or the first row of data items are used to create column headings. If the RowSourceType property is set to Table/Query, the field names are used as column headings. If the field has a caption, then the caption is displayed. For example, if a list box has three columns and the RowSourceType property is set to Table/Query, the first three field names are used as headings. If the RowSourceType property is set to Value List, the first row of data items entered in the Value List will be column headings.
When the first row of data items are used as column headings, they can’t be selected.
Headings in combo boxes appear only when the list drops down.
BoundColumn Property, ColumnCount Property, ColumnHeadings Property, ColumnWidths Property, ControlSource Property, ListRows Property, ListWidth Property.