about 'autocomplete'

[KiZa7]

I hope this isn't too stupid of a question but I've been trying to find a way to activate some kind of autocomplete function to help while entering data in a table and couldn't find it. So if for example, in a field in the table, I write data multiple times, access could autocomplete the words already seen, the way it's done when a field has the look-up option...Was wondering if there's a way for that..

Regards

 

[WayneRyan]

K,

For combo-boxes, that would be the AutoComplete property.

For a textbox, I'd assume that you'd have to use the OnChange event
and use the .Text component to guide the user.

No shortcuts here that I know of,
Wayne

 

[KiZa7]

Hey, thanks for your answer Wayne. I'll have to see later what you meant about OnEvent and .text but for now I'm just gonna write all the possible values in the look-up field and update it as new values come along...

 

[Bat17]

I'm just gonna write all the possible values in the look-up field and update it as new values come along

You could base the lookups on a query that pulls the values you want from your table. set the query to 'grouped' to avoid duplicates.
HTH

 

[StephenSLR]

access could autocomplete the words already seen

I am using a database that I didn't design and is locked by the designer.

Is there a way to switch on an autocomplete to fill in data I add into the text boxes - just like it does in MS excel?

s