u.s. state list

[Gary]

I have my state field as a combo box bound to a states table.

It works fine. It even autofills as you type.

My question - I have seen and used on the internet when entering addresses
that when you enter the state it doesn't just autofill but will continue to
the next state beginning with that letter every time you hit the letter.

For example, to get to Texas, I would hit a 'T'. Alphabetically, the first
state that shows is TN for Tennessee. To get to Texas I would just hit 'T'
again to go to the next 'T' state.

Is this possible to do in Access? If not, it works fine by autofill or by
pulling down the list.

Thanks.

Gary

 

[Ken Snell \(MVP\)]

A listbox will do what you seek. Comboboxes do not do this.

 

[Dirk Goldgar]

I have my state field as a combo box bound to a states table.

It works fine. It even autofills as you type.

My question - I have seen and used on the internet when entering
addresses that when you enter the state it doesn't just autofill but
will continue to the next state beginning with that letter every time
you hit the letter.

For example, to get to Texas, I would hit a 'T'. Alphabetically, the
first state that shows is TN for Tennessee. To get to Texas I would
just hit 'T' again to go to the next 'T' state.

Is this possible to do in Access? If not, it works fine by autofill
or by pulling down the list.

Access list boxes work that way, but combo boxes don't. You could
probably use some fancy code to make a combo box work that way, but it
isn't built-in, and I'm not convinced it's really worth it. As a user,
I generally prefer the default combo-box auto-expand behavior to the
list box "first-letter" behavior.