Would like to share how I managed to do an incremental search on a list box on any column.
Suppose the listbox has two columns viz. Name and address. So, I create three columns like Name, Name and Address by selecting rowsourcetype as, fields. Next, I hide the first column by making column width =0. So by dynamically changing the first column I could get the list box incrementally searched on any column I like since you cannot do incremental search on any other column except the first column in a list box. Whereas the first column is actually getting incrementally searched, it would appear that I am doing incremental search on the 2nd 3rd or 4th column or any other column.
Any other ideas on how to do the same thing in some other way?