Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

ACC2000: MultiSelect Property Works Differently Than Expected


View products that this article applies to.

This article was previously published under Q208796
Moderate: Requires basic macro, coding, and interoperability skills.

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).

↑ Back to the top


Symptoms

When you set the MultiSelect property of a list box to Simple or Extended, the selection behavior may work differently than you expect. For example, if the MultiSelect property is set to Simple, the SHIFT and CTRL keys have no effect when you click individual items. Or, if the MultiSelect property is set to Extended, you can use the SHIFT key and a mouse click to select a contiguous group of items, but you lose the group when you release the SHIFT key and then click an individual item.

Also, if the MultiSelect property of the list box is set to Simple or Extended, the selections that you make in the list box are deselected when you switch to Print Preview or you print the form.

↑ Back to the top


Cause

When the MultiSelect property is set to Simple, you can select multiple items by clicking each item individually. The SHIFT and CTRL keys cannot help you in selecting a group of items. When the MultiSelect property is set to Extended, you can use SHIFT and a mouse click to select a group of contiguous items. Or, you can use CTRL and a mouse click to select a group of non-contiguous items. After you select a group using SHIFT and a mouse click, you can retain the contiguous group and select additional non-contiguous items using CTRL and a mouse click. If you use only a mouse click after SHIFT and a mouse click or CTRL and a mouse click, you lose the group selection.

↑ Back to the top


More information

Steps to Reproduce Behavior

  1. Start Microsoft Access and open the sample database Northwind.mdb.
  2. Make a copy of the Sales Reports Dialog form and call it Test List Box.
  3. Open the Test List Box form in Design view.
  4. Change the MultiSelect property of the SelectCategory list box to Simple.
  5. View the Test List Box form in Form view.
  6. Click the Sales By Category button to enable the list box.
  7. Select and clear multiple items in the list by clicking the items individually. Note that this is the correct behavior when the MultiSelect property is set to Simple.
  8. View the Test List Box form in Design view.
  9. Change the MultiSelect property of the SelectCategory list box to Extended.
  10. View the Test List Box form in Form view.
  11. Click the Sales By Category button to enable the list box.
  12. Select multiple items in the list by using the following techniques:

    - Use the SHIFT key and a mouse click to select a contiguous group of items.

    - Use the CTRL key and a mouse click to select multiple non-contiguous items.

↑ Back to the top


References

For more information about the MultiSelect property of a list box, click Microsoft Access Help on the Help menu, type multiselect property in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

↑ Back to the top


Keywords: KB208796, kbprb

↑ Back to the top

Article Info
Article ID : 208796
Revision : 2
Created on : 6/30/2004
Published on : 6/30/2004
Exists online : False
Views : 285