Edit

ListBox.MultiSelect property (Access)

  • Article

Use the MultiSelect property to specify whether a user can make multiple selections in a list box on a form and how the multiple selections can be made. Read/write Byte.

Syntax

expression.MultiSelect

expression A variable that represents a ListBox object.

Remarks

The MultiSelect property uses the following settings.

Setting Visual Basic Description
None 0 (Default) Multiple selection isn't allowed.
Simple 1 Multiple items are selected or deselected by choosing them with the mouse or by pressing the Spacebar.
Extended 2 Multiple items are selected by holding down Shift and choosing them with the mouse, or by holding down Shift and pressing an arrow key to extend the selection from the previously selected item to the current item. You can also select items by dragging with the mouse. Holding down Ctrl and choosing an item selects or deselects that item.

This property can be set only in form Design view.

Use the ListIndex property to return the index number for the selected item. When the MultiSelect property is set to Extended or Simple, you can use the list box's Selected property or ItemsSelected collection to determine the items that are selected. In addition, when the MultiSelect property is set to Extended or Simple, the value of the list box control will always be null.

If the MultiSelect property is set to Extended, requerying the list box clears any selections made by the user.

Example

To return the value of the MultiSelect property for a list box named Country on the Order Entry form, you can use the following.

Dim b As Byte b = Forms("Order Entry").Controls("Country").MultiSelect

To set the MultiSelect property, you can use the following.

Forms("Order Entry").Controls("Country").MultiSelect = 2 ' Extended.

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.