Users can select only one item from a combo box. Users can select only one item from a drop-down list.Ĭombo boxIf you want your users to be able to type their own list entry or choose a value from a predefined list, use a combo box instead of a multiple-selection list box. However, with drop-down list boxes, the list entries are hidden until the user clicks the control. Like a multiple-selection list box, a list box displays all of the items in the list by default.ĭrop-down list boxLike any other list, a drop-down list box offers users a list of choices. However, with a list box, users can select only one item in the list. List boxLike a multiple-selection list box, a standard list box allows users to select values in a list. To decide which of these controls works best on your form template, refer to the following list: Microsoft Office InfoPath includes controls that are similar to multiple-selection list boxes but that serve different purposes. In the Multiple Selection List Box Properties dialog box, you can type the entries yourself or configure the multiple-selection list box to retrieve entries from a database or other data source.

Otherwise, users will see an empty box when they open a form that is based on your form template. Consequently, users can enter a value in an empty box next to the last check box in the list.Īfter you insert a multiple-selection list box on your form template, you must specify the values that you want to appear in it. The form designer has chosen to permit custom categories. In the following illustration, users can assign expenses in an expense report form to multiple categories by selecting check boxes in a multiple-selection list box. Show most or all of the items in a list on the form by default.ĭisplay values retrieved from a fixed list, from the form template's data source, or from an external data source, such as a database or Microsoft Windows SharePoint Services list. Use a multiple-selection list box when you want to:Įnable users to select multiple items in a list.Įnable users to type their own value in a list. When to use a multiple-selection list box When to use a multiple-selection list box.

Drop down list in excel