Show all combobox entries while typing

EnginerdUNH
2StarLounger
Posts: 114
Joined: 14 Aug 2019, 00:12

Show all combobox entries while typing

Post by EnginerdUNH »

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.

User avatar
Gasman
2StarLounger
Posts: 157
Joined: 22 Feb 2022, 09:04

Re: Show all combobox entries while typing

Post by Gasman »

Google FAYT if you want anywhere in the text
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.

George Hepworth
NewLounger
Posts: 18
Joined: 13 Jun 2024, 12:24

Re: Show all combobox entries while typing

Post by George Hepworth »

Here's a link to a classic Find as You Type method: http://allenbrowne.com/ser-32.html