MS Access Using a Key for Multiple Selections
MS Access 2016 - I have a LIST BOX and the user wants to be able to Select multiple entries using the SHIFT Key. Example -1 to 100 entries. He wants to select 20 to 30 with the shift key, and 50 to 55, etc.
No need for Shift...just change the option of Listbox to MultiSelect (simple)
Design View --select the ListBox -->Properties --"Other" Tab --> MultiSelect --Simple or Extended(Extended wants SHIFT)
https://support.office.com/en-us/article/multiselect-property-e382a2e2-9e3e-44ac-a8df-668c72adb5a3
Design View --select the ListBox -->Properties --"Other" Tab --> MultiSelect --Simple or Extended(Extended wants SHIFT)
https://support.office.com/en-us/article/multiselect-property-e382a2e2-9e3e-44ac-a8df-668c72adb5a3
As John said, turn on the Multi-Select. Then it's standard Windows key's.
1. Click first,hold shift, click on last.
2. Use Ctrl To select/un-select individual entires, etc.
With multi select on, you'll need to use the Selected property to determine which have been selected for processing:
https://docs.microsoft.com/en-us/office/vba/api/access.listbox.selected
Jim.
Premium Content
You need an Expert Office subscription to comment.Start Free Trial