Hide a column in a list box or combo box in a form

Hide a column in a list box or combo box in a form

  1. Open the form in Design view.

  2. Make sure the list box or combo box is selected, and then click Properties on the toolbar to open the property sheet for the control.

  3. In the ColumnWidths property box, enter 0 for the column or columns that you want to hide.

For example, suppose you have a bound two-column combo box that has a SupplierID column and a SupplierName column. The SupplierID column is the first column in the list. To hide the SupplierID column, set the ColumnWidths property as shown in the following illustration.

Hide columns by using the ColumnWidths property

Note   In a combo box, the first visible column is displayed in the text box portion of the combo box when the list isn't displayed. For example, the SupplierName column in the previous example would be displayed because the SupplierID column is hidden. If the SupplierID column weren't hidden, then it would be the only column that was displayed.