Addresses on Forms

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Newbie - 15 Jan 2005 18:19 GMT

Hi,

Anyone have an idea as to where I can get either a list or table of
two-character State abbreviations to use for inputting addresses?
Thanks,

Signature

jan

Reply to this Message

Ed Warren - 15 Jan 2005 19:50 GMT

Copy the list below and import into Access
Ed Warren
--------------------------------------------------
Abbreviation,Name
AK,ALASKA
AL,ALABAMA
AR,ARKANSAS
AS,AMERICAN SAMOA
AZ,ARIZONA
CA,CALIFORNIA
CO,COLORADO
CT,CONNECTICUT
DC,DISTRICT OF COLUMBIA
DE,DELAWARE
FL,FLORIDA
FM,FEDERATED STATES OF MICRONESIA
GA,GEORGIA
GU,GUAM
HI,HAWAII
IA,IOWA
ID,IDAHO
IL,ILLINOIS
IN,INDIANA
KS,KANSAS
KY,KENTUCKY
LA,LOUISIANA
MA,MASSACHUSETTS
MD,MARYLAND
ME,MAINE
MH,MARSHALL ISLANDS
MI,MICHIGAN
MN,MINNESOTA
MO,MISSOURI
MP,NORTHERN MARIANA ISLANDS
MS,MISSISSIPPI
MT,MONTANA
NC,NORTH CAROLINA
ND,NORTH DAKOTA
NE,NEBRASKA
NH,NEW HAMPSHIRE
NJ,NEW JERSEY
NM,NEW MEXICO
NV,NEVADA
NY,NEW YORK
OH,OHIO
OK,OKLAHOMA
OR,OREGON
PA,PENNSYLVANIA
PR,PUERTO RICO
PW,PALAU
RI,RHODE ISLAND
SC,SOUTH CAROLINA
SD,SOUTH DAKOTA
TN,TENNESSEE
TX,TEXAS
UT,UTAH
VA,VIRGINIA
VI,VIRGIN ISLANDS
VT,VERMONT
WA,WASHINGTON
WI,WISCONSIN
WV,WEST VIRGINIA
WY,WYOMING

--------------------------------------------------

> Hi,
>
> Anyone have an idea as to where I can get either a list or table of
> two-character State abbreviations to use for inputting addresses?
> Thanks,

Reply to this Message

Newbie - 16 Jan 2005 20:23 GMT

Thank you!

> Copy the list below and import into Access
> Ed Warren
[quoted text clipped - 66 lines]
> > two-character State abbreviations to use for inputting addresses?
> > Thanks,

Reply to this Message