AUTO FOCUS IN DROP DOWN

[jpe2007]

Hi everyone, if I was to have a drop down box with the following information in it:

Adrian, Brian, Bob, Nancy, Nicole, Sam, Sean, Steve, Tim

How do I create the drop down on a form so that I can type the name in the drop down and it automatically goes to the first name etc.

So if I type B it would go to Bob and show Bob so if I then clicked on the drop down it would show Brian next and so on

Or if I type N it would show Nancy but if I then type I so I now have NI it would focus on Nicole?

My list of names is close to 500 much larger than this example and for ease of entry it would be great if people could type the first few letters of the name and then open the drop down vs. starting at the top and having to scroll 500 names each time.

I look forward to any help that could be offered thanks.

 

[PHV]

Have a look to the AutoExpand property.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886