Two Digit State Codes for MS Access


Here’s a list of two digit state codes separated by semicolons. You can use them as the row source for a drop-down box in Access when the Row Source for your combo box is set to Value List. Hope you find this helpful. Over time, I’ll add resources such as these, data tables and whatnot. Hopefully things like this will make your job a little easier if you’re working on a database.

AK;AL;AR;AZ;CA;CO;CT;DC;DE;FL;GA;HI;IA;ID;IL;IN;KS;KY;LA;MA;MD;

ME;MI;MN;MO;MS;MT;NC;ND;NE;NH;NJ;NM;NV;NY;OH;OK;OR;PA;RI;

SC;SD;TN;TX;UT;VA;VT;WA;WI;WV;WY

I had to split up the lines. You’ll need to copy/paste the states into notepad and take out the linefeeds.

Comments are closed.