Rabu, 10 April 2013

[AccessDevelopers] Customized combo box

 

Thanks in advance for your help.
I want to create a custom combo box to select property addresses. I have a combo box that is populated by the cities in a data table but I want limit the combo list to match only what I have already typed.

For example, if the cities are: Anton, Auxwell, Baer, Badwater, Baker, Buda, Burbank, Camden, Cribbage, etc.
When I start the form, the combo box should list all cities, but as soon as I type "B" or "b", the combo box should only have cities starting with b. Then I type "u" and the box will redisplay/refresh only cities starting with "bu*"

This is similar to how Access10 builds a combo box and then selects the matching record. However, I want the combo box to drop down and start displaying possible matches as soon as the user starts typing (so they don't have to click on the dropdown) and I don't want to display following unmatched records. With the combo box I build using the wizard, I can type "Bu" and it positions the list to show Buda, Burbank, Camden, Cribbage, etc. but I don't want to show Camden, Cribbage or others.

Thanks.
Thank you.

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)
Recent Activity:

Please zip all files prior to uploading to Files section.
.

__,_._,___

Tidak ada komentar:

Posting Komentar