Form Field with Predictive Text

[okiiyama]

I would like to have a field that uses some sort of "Predictive Text." And the predictive text that is being displayed while the user is typing in the field is a column in a table.

Is there an easy way to do this?

THanks.

 

[Mike555]

Why not simply use a combo box?

--
Mike

 

[okiiyama]

There is over 600 hundred PO numbers

 

[Mike555]

Could you be a little more specific about what it is that you need to accomplish?

--
Mike

 

[okiiyama]

Yeah.
Ive got a search form that will search for a Purchase Order record. One field to search by is PONumber. What I would like to have is that after each digit is typed into the form field a query is performed and will predict and auto-complete the field.

If X is typed, it would look for all PONumber = X*, then it would show the first PONumber returned from that query in the PONum search field. Then Y is typed so now the query would be PONumber = XY* and the first PONumber returned from the query will display in the field...This process will be repeated for all the 6 digits typed.

If this isn't very feasible then maybe I would like a read-only field that is a listbox that after each digit is pressed in the PONum search field, it would display the PONumbers starting with that substring.

Is this clear?

Thanks for helping.

 

[Mike555]

The only suggestion I would have is to try using a combobox which bound to your Po#s datasource. The combo box has an auto-complete feature, which isn't as robust as you've desribed here, it'll only show you one option at a time, not all options.

--
Mike