Validation rule: Valid_US_State_in_Address

Name

Valid_US_State_in_Address

Label

Valid_US_State_in_Address

Object

AQB__AQAddress__c

Active

No

Formula

AND (
OR( AQB__Country__c = "US", AQB__Country__c ="United States",AQB__Country__c ="USA", ISBLANK(AQB__Country__c )),
LEN( AQB__City__c )>0,
NOT(
CONTAINS("AL;Alabama:AK:Alaska:AZ:Arizona:AR:Arkansas:CA:California:" & "CO:Colorado:CT:Connecticut:DE:Delaware:" & "DC:District of Columbia:FL:Florida:GA:Georgia:HI:Hawaii:ID:Idaho:" & "IL:Illinois:IN:Indiana:IA:Iowa:KS:Kansas:KY:Kentucky:" & "LA:Louisiana:ME:Maine:MD:Maryland:MA:Massachusetts:" & "MI:Michigan:MN:Minnesota:MS:Mississippi:MO:Missouri:" & "MT:Montana:NE:Nebraska:NV:Nevada:NH:New Hampshire:" &
"NJ:New Jersey:NM:New Mexico:NY:New York:" & "NC:North Carolina:ND:North Dakota:OH:Ohio:OK:Oklahoma:" & "OR:Oregon:PA:Pennsylvania:RI:Rhode Island:SC:South Carolina:" & "SD:South Dakota:TN:Tennessee:TX:Texas:UT:Utah:VT:Vermont:VA:Virginia:" &
"WA:Washington:WV:West Virginia:WI:Wisconsin:WY:Wyoming:" & "AS:American Samoa:FM:Federated States of Micronesia:GU:Guam:" & "MH:Marshall Islands:PW:Palau:PR:Puerto Rico:VI:Virgin Islands:AA:AE:AP", AQB__StateProvince__c )
))

Error message

A valid two-letter state code is required.

Error location

State/Province