MajP
You've got your good things, and you've got mine.
- Local time
- Today, 18:15
- Joined
- May 21, 2018
- Messages
- 8,656
Here is an Find/Filter as You Type (FAYT) class. This allows you to find/filter lists of comboboxes, listboxes, and continuous forms. The class helps create the capability with a single line of code to instantiate the class.
You need to import the class module. Then instantiate a FAYT variable.
1. Auto expands
2. Handles apostrophes
3. Handles international characters as demonstrated by the test case.
4. Can be configured to search anywhere in string or from beginning only
5. Can search a multi column combobox.
6. Handles up and down arrow keys.
You need to import the class module. Then instantiate a FAYT variable.
1. Auto expands
2. Handles apostrophes
3. Handles international characters as demonstrated by the test case.
4. Can be configured to search anywhere in string or from beginning only
5. Can search a multi column combobox.
6. Handles up and down arrow keys.
Attachments
Last edited: