Is auto complete in form fields possible?

[Guest]

Just wondering if there is anything you can download or some kind of addon
for access that allows people to auto complete some thing like name fields in
form field?

 

[Dirk Goldgar]

Just wondering if there is anything you can download or some kind of
addon for access that allows people to auto complete some thing like
name fields in form field?

I guess that depends on what you're after. You can use a combo box, and
bind it to a query of the form's recordsource, if you want to
autocomplete from the values that have previously been entered into that
field. To keep it up to date, you have to requery it in the form's
AfterUpdate event. And if you realy want to do this yourself with a
text box, you can write code to do it. However, the guiding principle
of relational databases is not to store the same information multiple
times, and that reduces the number of situations where autocomplete is
really appropriate for a text box.