Hello. I have a form with a list box. The user selects a radio button from an option group and the list box populates based upon the selection. My user now wants the ability to type the first few characters in a string and have it find the right value in the list box, particularly when there are hundreds of items in the list box. Is there a way to do this? Thanks in advance.
Auto-filling a list box
- Thread starter poet1234
- Start date
Have a look at the following thread, there are a couple of examples of the sort of thing you are looking for: http://www.access-programmers.co.uk/forums/showthread.php?t=79620
HTH
HTH
Quick, dumb question: how would I modify the code in your example to work with a list box where the values are not text. I tried it with a list box containing currency values and it doesn't work. Any suggestions would be much appreciated. Thanks.
That's going to be a bit more difficult due to the way Access lists values. i.e. you have the values 1, 2, 11, 112. If you list them ascending, Access will list them the way I have typed them in, but in order for the example to work they would need to be 1, 11, 112, 2 as you could then type in '1' and it would take you to all numbers beginning with '1'.
Let me have a play with this over the weekend, unless anyone else already has the solution?
Let me have a play with this over the weekend, unless anyone else already has the solution?
