All States DropDown

[rry2k]

Hi,

I need to populate a drop down with all the state abreviations. Does someone have this string available?

Thanks..Russ

 

[LonnieJohnson]

Here is a list of the states you can cut and paste into a table:

AL
AK
AZ
AR
CA
CO
CT
DE
DC
FL
GA
GU
HI
ID
IL
IN
IA
KS
KY
LA
ME
MD
MA
MI
MN
MS
MO
MT
NE
NV
NH
NJ
NM
NY
NC
ND
OH
OK
OR
PA
PR
RI
SC
SD
TN
TX
UT
VT
VI
VA
WA
WV
WI
WY
prodevmg@yahoo.com
ProDev, MS Access Applications B-)

http://www.galaxymall.com/software/PRODEV

May God bless you in the year 2002.

 

[rry2k]

Thanks and have a great weekend..Russ

 

[JoeMiller]

I'm just pasting this in as well for future people who may want this with the StateName. I've also including the Canadian states as they are somtimes wanted along with a country code.

[tt]
State or Province Country Code
Alberta CA AB
British Columbia CA BC
Manitoba CA MB
New Brunswick CA NB
Newfoundland CA NF
Northwest Territories CA NT
Nova Scotia CA NS
Ontario CA ON
Prince Edward Island CA PE
Quebec CA PQ
Saskatchewan CA SK
Yukon CA YT
Alabama US AL
Alaska US AK
Arizona US AZ
Arkansas US AR
California US CA
Colorado US CO
Connecticut US CT
Delaware US DE
District of Columbia US DC
Florida US FL
Georgia US GA
Hawaii US HI
Idaho US ID
Illinois US IL
Indiana US IN
Iowa US IA
Kansas US KS
Kentucky US KY
Louisiana US LA
Maine US ME
Maryland US MD
Massachusetts US MA
Michigan US MI
Minnesota US MN
Mississippi US MS
Missouri US MO
Montana US MT
Nebraska US NE
Nevada US NV
New Hampshire US NH
New Jersey US NJ
New Mexico US NM
New York US NY
North Carolina US NC
North Dakota US ND
Ohio US OH
Oklahoma US OK
Oregon US OR
Pennsylvania US PA
Rhode Island US RI
South Carolina US SC
South Dakota US SD
Tennessee US TN
Texas US TX
Utah US UT
Vermont US VT
Virginia US VA
Washington US WA
West Virginia US WV
Wisconsin US WI
Wyoming US WY
[/tt] Joe Miller
joe.miller@flotech.net