If you like my Reference Database, please
donate so I can keep on developing.
thanks to Arvin Meyer for setting up this site
and giving Access MVPs a place to share with others.
Access database contains these tables:
- Zip Codes
— Zip, City, State, County, Latitude, Longitude -- US Zips
— Country Codes and Country Names
— State Abbreviations and State Names for the United States, Canada, and Military
— Telephone Area codes for the United States
— International Dialing codes for Phone calls
— Airline Name and IATA codes for Airlines around the world, includes base Country and airline note
(535 records) - updated Aug 6, 2009
— Airport Name and IATA codes for Airports around the world, includes City and Country (and State for USA)
(2,750 records) - updated Aug 6, 2009
- Sample form
— Example form showing 3 types of comboboxes to collect State. For more information, read the combobox example in Access Basics.
(Nov 23, 2011)
Access 2013 version also has tables for Voltages, Flowers, ...
How do I set up a drop down box for state abbreviations in Access?
Thanks for your question, Jodi.
I have added a sample form to the reference database showing how to set up 3 different types of comboboxes:
- combobox showing all states. Calculated textbox controls show Statename, Country code, IsActive flag
- combobox showing states with Active flag set. Calculated textbox controls show Statename, Country code.
- cascading combobox to pick Country and then State. Requery on AfterUpdate event of Ctry. Criteria in RowSource of State. Calculated control shows statename.
for information on private programming and training,
or if you have comments and ideas, I'd love to hear from you
Copyright © 2009-2015 Crystal Long | All rights resorved | Last Updated November 2015 |