Share via

List Items Tab, Combo Box Builder

  • Article

The List Items tab in the Combo Box Builder specifies items that go into the combo box. The other Combo Box Builder tabs are: Layout, Style, and Value.

When you choose OK, the builder closes, applying the property settings from every tab to the control.

  • Fill the List With
    Specifies the kind of data with which to fill the combo box list. The selection you make here determines which choices appear on this tab. Choose Fields From a Table or View, Data Entered by Hand, or Values From an Array.

  • Fields From a Table or View
    Allows you to select free tables or tables and views from a database to use in the combo box.

  • Databases and Tables
    Lists the available databases and gives the option to select Free Tables. To find a database or table, click the dialog button, which displays the Open dialog box. This option appears when you have selected Fields From a Table or View in the Fill the List With drop-down list.

  • List of Tables
    Displays tables and views in the selected database, or free tables. This option appears when you have selected Fields From a Table or View in the Fill the List With drop-down list.

  • Available Fields
    Shows all fields in the selected table or view. Select the fields whose data you want in your combo box. This option appears when you have selected Fields From a Table or View in the Fill the List With drop-down list.

  • Arrow Buttons
    Adds fields to and removes fields from the Selected Fields box. This option appears when you have selected Fields From a Table or View in the Fill the List With drop-down list.

    You can also double-click an item to move it between lists.

  • Selected Fields
    Displays the fields that will be used to fill the combo box list. The order of the fields selected will correspond to the order of the columns in the combo box. This option appears when you have selected Fields From a Table or View in the Fill the List With drop-down list.

  • Data Entered By Hand
    Allows you to select the number of columns to be displayed in the combo box and enter the information to be displayed.

  • Columns
    Specifies the number of columns in the combo box list. This option appears when you have selected Data Entered By Hand in the Fill the List With drop-down list.

  • Column Grid
    Displays the columns in which to enter data. Type the data in the column cells. You can size the columns by dragging the lines between them with the mouse. This option appears when you have selected Data Entered By Hand in the Fill the List With drop-down list.

  • Values From An Array
    Allows you to use data from an array within the combo box.

  • Array Name
    Specifies the name of an array. This option appears when you have selected Values From An Array in the Fill the List With drop-down list.

  • Entire Array
    Specifies that the entire array will fill the combo box list. This option appears when you have selected Values From An Array in the Fill the List With drop-down list.

  • Range Of The Array
    Specifies that a part of the array will fill the combo box list based on the column and row settings. This option appears when you have selected Values From An Array in the Fill the List With drop-down list.

  • Column and Row Range
    Specifies the starting and ending column and row as the array range. These options are only available when you select Range of the Array. This option appears when you have selected Values From An Array in the Fill the List With drop-down list.

For more information, see "Creating an Array Property" in Adding Properties and Methods to a Form, under Creating Forms.

See Also

Combo Box Builder | ControlSource Property | Layout Tab, Combo Box Builder | Open Dialog Box | RowSource Property | RowSourceType Property | Style Tab, Combo Box Builder | Value Tab, Combo Box Builder