auto complete fields

[mona]

I'm using Microsoft Access 2007. When I start typing a new record in a form ,is there a way to get access to suggest things I've previously typed,or stored in another table to save me time typing the whole word in? For example when I start typing S, it might start suggesting words that I've already typed beginning with S, then if I type ST it might suggest STATION and I can just press enter to insert that word? exactly like google do ... and thank you in advance

[Robeen]

I'm not absolutely certain of this because I've never used Access 2007 . . . but you might be able to get what you want with a Combo Box.
It works in Access 2010.

'Bind' your Combo Box to the field that holds the data you'd like to get your text from.
Once you start typing in the Combo box Access should take you to the closest match from the field that the Combo Box is bound to.

Hope this helps!

[mona]

thank you robeen but i want something like jquery,function or code is there something like that ???

[orange]

You may get some ideas here
http://allenbrowne.com/AppFindAsUType2.html