A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

u.s. state list



 
 
Thread Tools Display Modes
  #1  
Old December 15th, 2005, 01:25 AM posted to microsoft.public.access.forms
external usenet poster
 
Posts: n/a
Default 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  
Old December 15th, 2005, 04:50 PM posted to microsoft.public.access.forms
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 09:25 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.