Autofill form field

[ghadley_00]

Hi,

I have an access database with forms. I was wondering if there was a
way to make a form field do an autocomplete action during data entry
based on values already in that field for other records? In other
words, if I were to enter the letter J into a field, an autocompletion
of the alphabetically first entry in the table for that field beginning
with J is filled in, and the list would get refined based on further
letters entered.

Any help any one could provide would be greatly appreciated.

Best wishes,

George Hadley
(e-mail address removed)

 

[Brian Bastl]

generally achieved using a combo box.

HTH,
Brian

 

[Jeff Boyce]

Sounds like the AutoExpand property of a combo box control.