Chart Control, Combo Box Control, List Box Control, Table Fields, Unbound Object Frame Control.
You can use the ColumnCount property to specify the number of columns displayed in a list box, or in the drop-down portion of a combo box, or sent to OLE objects in a chart or object frame. For example, if you set the ColumnCount property for a list box on an Employees form to 3, one column can list last names, another can list first names, and the third can list employee ID numbers.
The ColumnCount property holds an Integer between 1 and the maximum number of fields in the table, query, or SQL statement specified in the RowSource property of the control.
You can set the ColumnCount 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.
A combo box or list box can have multiple columns. If the control’s RowSource property contains the name of a table, query, or SQL statement, a combo box or list box will display the fields from that source, from left to right, up to the number specified by the ColumnCount property.
To display a different combination of fields, create either a new query or a new SQL statement for the RowSource property, specifying the fields and the order you want.
You can use the ColumnWidths property to set the width of the columns displayed in the control.
BoundColumn Property, Column Property, ColumnHeads Property, ColumnWidths Property, ControlSource Property.
See the Column property example.