Predictive text field

[Duncaninnz]

I need to create a field in a form that mimics the way excell would handle a
column of text . That is when keying say t and there is already a previous
entry of Tuesday it would drill down to the comparable field. I know I can
create a lookup but the bit I cant mimic is a new entry. Excell would just
give up predictive text and make a new entry. eg t would predict tuesday but
key th and there is no pevious entry for beginning with th it will
effectively switch to record entry and add the filed to the column.

 

[John Vinson]

I need to create a field in a form that mimics the way excell would handle a
column of text . That is when keying say t and there is already a previous
entry of Tuesday it would drill down to the comparable field. I know I can
create a lookup but the bit I cant mimic is a new entry. Excell would just
give up predictive text and make a new entry. eg t would predict tuesday but
key th and there is no pevious entry for beginning with th it will
effectively switch to record entry and add the filed to the column.

Use a Form (*NOT* a table datasheet) to do your data entry, and - if
this field has a defined set of values - use a Combo Box control.

If it doesn't have a limited or limitable list of values, you can
write VBA code in the textbox's Change event to look up the values
which already exist - but it would be a fair bit of code and somewhat
tricky to implement.


John W. Vinson[MVP]