I have a combo box with rowsource
Select cust_name from customers order by cust_name.
When i type text in the combo-box , the list portion of the combo-box automatically scrolls to display the matching values if a name starts with the text i have typed.
For eg. if i type "C" the list portion will be like
Carmen
Cathy
Charles
Cindy
and so on
But if i type "Ce" , since no name starts with "Ce" in my table the list portion displays the starting records
Aby
Amy
Arnold
Arvind
Is it possible (using any API/function/trick etc.) that , the list portion shows the closest matching records so user will find it easy to select if he has made a spelling mistake earlier ?
For eg. with "Ce" the list should display though no names start with "Ce"
Charles
Cindy
Colin
Cummins
This would make the use of combo-boxes much more effective in case of name selection.
Select cust_name from customers order by cust_name.
When i type text in the combo-box , the list portion of the combo-box automatically scrolls to display the matching values if a name starts with the text i have typed.
For eg. if i type "C" the list portion will be like
Carmen
Cathy
Charles
Cindy
and so on
But if i type "Ce" , since no name starts with "Ce" in my table the list portion displays the starting records
Aby
Amy
Arnold
Arvind
Is it possible (using any API/function/trick etc.) that , the list portion shows the closest matching records so user will find it easy to select if he has made a spelling mistake earlier ?
For eg. with "Ce" the list should display though no names start with "Ce"
Charles
Cindy
Colin
Cummins
This would make the use of combo-boxes much more effective in case of name selection.
