Hi,
I am wondering if it’s possible to click on a combobox on a form to expand it and show all row values, filtering it in real time as the user types their desired keyword(s) for example, if a combobox had the words “apple”, “pear”, “banana” and “pineapple”, all of these would show up at first but then as the user starts typing, let’s say they type “a”, still everything shows because they all have “a” but if they type “ap”, only “apple” and “pineapple” appear.
Show all combobox entries while typing
-
- 2StarLounger
- Posts: 114
- Joined: 14 Aug 2019, 00:12
-
- 2StarLounger
- Posts: 157
- Joined: 22 Feb 2022, 09:04
Re: Show all combobox entries while typing
Google FAYT if you want anywhere in the text
Look at the Dropdown method of the combo for non FAYT
Look at the Dropdown method of the combo for non FAYT
You do not have the required permissions to view the files attached to this post.
Using Access 2007/2019.
Give a man a fish and you feed him for a day. Teach a man to fish and you feed him for a lifetime.
Please, please use code tags when posting code snippets, click the </>icon.
Debug.Print is your lifesaver.
Give a man a fish and you feed him for a day. Teach a man to fish and you feed him for a lifetime.
Please, please use code tags when posting code snippets, click the </>icon.
Debug.Print is your lifesaver.
-
- NewLounger
- Posts: 18
- Joined: 13 Jun 2024, 12:24
Re: Show all combobox entries while typing
Here's a link to a classic Find as You Type method: http://allenbrowne.com/ser-32.html