Does Access have an autocomplete feature (like Excel) that I can u

  • Thread starter Access Autocomplete?
  • Start date
A

Access Autocomplete?

The autocomplete feature in Excel is so handy. I would like to program my
Access database to include that feature. I know I could use a combo box, but
I think autocomplete is more user friendly for the data entry. Thanks for
any help...
 
A

Allen Browne

No. There is nothing built-in other than the combo.

It is possible to program it in the Change event of a text box, using the
Text property of the control, Len(), Mid(), SelStart(), SelLength(), etc, in
conjuction with a Recordset of other values.

But in general, you should not have lots of repeating values in a field. If
so, you probably need a lookup table of the possible values, and so a combo
would be appropriate.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

"Access Autocomplete?" <Access [email protected]>
wrote in message
news:[email protected]...
 
Top