Enable AutoComplete for cell values?

A

Albert D. Kallal

No, ms-access does not have that feature. The key sequence ctrl-' does work
in Excel, and also in ms-access (that means enter/copy the same value from
the previous entry.

While it might at first sight seem strange that ms-access does not have
autocomple, the work around is to provide a combo box. Using a combo box
will "match" as you type.

The advantage in ms-access is that a combo box also provides verification of
the input data. While auto-compile will save time, it also can make a mess
of your database. For a person's favorite color, we often see:


bluee
blu
bloo
Blue

Of course, of the colors blue, we really only want the person to type in
allowable colors from our colors list. When you use a combo box, the all
entries are EXACTLY the same..and thus when you have to search people who's
favorite color is blue, then you really start to see the benefits of
ms-access over Excel. Further, with buttons, combo boxes, listboxes, and
even code to pull data from other parts of the database, then data entry
compared to Excel is much faster, much more accurate (due to verification),
and also far easer for the data entry people.

So, likely a combo box for the particular text box on the form should
help/give you the auto complete type feature..but allow you to verify the
data entered in a far more structured fashion.
 
Top