Combo box selection

[MikeB]

If I have a combo-box with the abbreviations of the US states, I'd
like it to work as follows:

If I have two states with the same initial (Tennessee and Texas), if I
hit the "T" key repeatedly, I want the combo-box to select the second
state instead of filling in the combo-box with "tt". Is this possible?
I've seen many combo boxes that work that way, I just odn't know how
to do that.

Thanks.

 

[fredg]

If I have a combo-box with the abbreviations of the US states, I'd
like it to work as follows:

If I have two states with the same initial (Tennessee and Texas), if I
hit the "T" key repeatedly, I want the combo-box to select the second
state instead of filling in the combo-box with "tt". Is this possible?
I've seen many combo boxes that work that way, I just odn't know how
to do that.

Thanks.

Actually, I doubt very much that you have ever seen an Access Combo
box work the way you state. In an Access Combo Box set to AutoExpand =
Yes, entering a T will take you to the first state in the sort order
that begin with T. Entering a second T will result in a Not In List
error (unless you have an entry that begins with TT).
In a Combo Box, you would find the wanted value by entering TEN to get
Tennessee and not Texas.

A List box works the way you want, so use a List box instead of a
Combo Box.

 

[MikeB]

Actually, I doubt very much that you have ever seen an Access Combo
box work the way you state. In an Access Combo Box set to AutoExpand =
Yes, entering a T will take you to the first state in the sort order
that begin with T. Entering a second T will result in a Not In List
error (unless you have an entry that begins with TT).
In a Combo Box, you would find the wanted value by entering TEN to get
Tennessee and not Texas.

A List box works the way you want, so use a List box instead of a
Combo Box.

Listbox. Right, thanks.