B
Bob Barnes
As long as the Letter typed exists...I have AutoExpand enabled.
Can that be coded?
TIA - Bob
Can that be coded?
TIA - Bob
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
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
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
B
Bob Barnes
Allen - OnChange didn't work, because AutoExpand interfered w/ my If the
length was = 1..I'll try this.
Thank you - Bob
length was = 1..I'll try this.
Thank you - Bob
A
Allen Browne
In the Change event, examine the Text property of the combo (not its Value.)
B
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
Private Sub cboDBF_Change()
If Len(cboDBF.Text) > 0 Then cboDBF.Dropdown
End Sub
Thank you - Bob