How to do autocompleate in textbox or combobox

[goldpoints]

I want a textbox (or combobox) in an Access form that works like the URL bar
in IE in autocompleate mode. It should look for my previous entries in that
field and display all texts that matchs my first keystrokes, allowing me to
select one of list if i have typed already that text before, and allow me to
enter a new text in the list if the text is not already in it. I couldnt find
the autocompleate propriety in the texbox or combobox of Acess. Any hint?

 

[fredg]

I want a textbox (or combobox) in an Access form that works like the URL bar
in IE in autocompleate mode. It should look for my previous entries in that
field and display all texts that matchs my first keystrokes, allowing me to
select one of list if i have typed already that text before, and allow me to
enter a new text in the list if the text is not already in it. I couldnt find
the autocompleate propriety in the texbox or combobox of Acess. Any hint?

A Combo box has an AutoExpand property. Set it to Yes.

 

[Linq Adams via AccessMonster.com]

Micro$oft, of course, couldn't call it AutoComplete, like the rest of the
programming world! As Fred said, you can do this easily with a combobox.
Doing it with a textbox, ala Excel or a browser, while possible, is simply
not feasible! It would require checking each keystroke, doing a DLookup and
repeating until data entry was thru. This would slow your program down to a
very, very slow crawl.

The reason Excel has this feature and Access doesn't is quite simple; storing
redundant data in a spreadsheet is normal/allowed, while storing redundant
info in a database is violating the # 1Cardinal Rule!