In Access 2003, Is there anyway of having a combo box automatically drop down the underlying list, without clicking the dropdown button, as soon as the user starts typing in the box? (e.g. similar to the google search box).

I presume this would have to be done with an event procedure triggered by something like "on dirty". [ If that can be done, then there's the ancillary question of how to delete the dropdown button, since it would no longer be needed ]

Pete

Normally you'd just drop it down when it gets focus:

Pete,


Missinglinq's code will drop the the list. You also ask about makng it close. When the control has lost the focus, it will automatically close the drop down list.

TIP: F4 toggles the drop down list when the control has the focus.

You could try a text box on top of a list box, instead of using a combo box. Set the list box to requery for every textbox.onchange which would populate your list as you type.

Thanks to all. Missinglinq's one-liner was what I was looking for. I'd not found the Dropdown property when I was originally looking.
Pete