If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
u.s. state list
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 |
#2
|
|||
|
|||
u.s. state list
"Gary" wrote in message
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. -- Dirk Goldgar, MS Access MVP www.datagnostics.com (please reply to the newsgroup) |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
US State Abbreviations List | DTTODGG | New Users | 1 | November 16th, 2005 02:36 PM |
using first list box to populate choices in second list box | Giz | Using Forms | 2 | October 25th, 2005 04:51 PM |
E-mail Display name is wrong | Jane Nangle | Contacts | 9 | February 4th, 2005 11:05 AM |
Union Query Not Returning A Value | Jeff G | Running & Setting Up Queries | 2 | October 19th, 2004 05:47 PM |
synchronizing form and list box | Deb Smith | Using Forms | 8 | June 21st, 2004 08:15 PM |