AutoComplete feature !

[Jaafar Tribak]

Hi,

Is there an AutoComplete feature in Access like there is in Excel ?

Jaafar.

Thanks.

 

[Andrew Fergus]

Hi Jaafar.
In what context do you want to use the autocomplete? As far as I know, it is available for combo boxes but not for entering data into unbound text boxes or table cells.
Andrew

 

[Jaafar Tribak]

Hi,

I was thinking maybe I could set up a LookUp table for a field so when a Cell is selected in this field I can take advantage of the its AutoComplete feature.
Problem is how do I set up this LookUp table ?

Maybe I'll need a Macro to achieve this but I haven't got so far as to use macros with Access yet



Jaafar.

Thanks.

 

[Andrew Fergus]

You don't need to write a macro to do this. Useful resources from MS here :

Auto lookup query
Field that looks up values in tables
Field that looks up or lists values, and
Auto lookup queries that automatically fill in data.

Some of these are pretty similar but they should get you started.
HTH, Andrew