Auto-Fill A Field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I make a field fill as I type? For example: while I'm typing a name
in a name field, I would like the field to fill in the rest of the name
(obviously from names already entered into the database). Thanks.
 
How do I make a field fill as I type? For example: while I'm typing a name
in a name field, I would like the field to fill in the rest of the name
(obviously from names already entered into the database). Thanks.
Click to expand...

Base a Combo Box control on the table containing the names. It will by
default autocomplete.

Note that names are NOT unique. If these are people's names, you'll
need to deal with the fact that you might need to deal with two people
who just happen to share the same name (this is an issue that the FBI
and TSA haven't apparently succeeded in resolving with their list of
suspected terrorists provided to airlines... :-{( )

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Back
Top