ComboBox to Dropdown after 1st letter typed..

[Bob Barnes]

As long as the Letter typed exists...I have AutoExpand enabled.

Can that be coded?

TIA - Bob

 

[Allen Browne]

It's very easy to drop the combo box down in its Enter event:
Me.DropDown

If you want to respond to typing, use its Change event. You would need to
know whether the combo is already dropped down or not. Access doesn't
actually give you this, but it is possible to get it with an API call:
Determining Combobox's Dropped state
at:
http://www.mvps.org/access/api/api0052.htm

 

[Bob Barnes]

Allen - OnChange didn't work, because AutoExpand interfered w/ my If the
length was = 1..I'll try this.

Thank you - Bob

 

[Allen Browne]

In the Change event, examine the Text property of the combo (not its Value.)

 

[Bob Barnes]

It works..even w/ the AutoExpand.

Private Sub cboDBF_Change()
If Len(cboDBF.Text) > 0 Then cboDBF.Dropdown
End Sub

Thank you - Bob