auto complete

[Guest]

Is there a way to have a field start searching records as you are typing the
information your are looking for ? I have seen a lot of database programs do
this. Just wondering if access can do this. This would be compared to the
function that excell does when you enter information into a cell kinda like
auto complete.
Thanks T

 

[Rick B]

If the field is a combo box, this can happen.

 

[Brett Collings [429338]]

You can also make the list drop down when you give it the focus

Private Sub cboGetType_GotFocus()
Me.cboGetType.Dropdown
End Sub

BTW, we always set the number of rows to 50 instead of the generally
useless default 8.

Brett

If the field is a combo box, this can happen.

Cheers,
Brett