Link to home
Start Free TrialLog in
Avatar of ANTHONY CHRISTI
ANTHONY CHRISTIFlag for United States of America

asked on

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.
ASKER CERTIFIED SOLUTION
Avatar of John Tsioumpris
John Tsioumpris
Flag of Greece image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of ANTHONY CHRISTI

ASKER

Thank you very Much.

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.