Validation rule: Valid_US_State_Permanent_Address_Abbrev

Name

Valid_US_State_Permanent_Address_Abbrev

Label

Valid_US_State_Permanent_Address_Abbrev

Object

Account

Active

No

Formula

AND (
OR( AQB__AccountDefaultCountry__c = "US", AQB__AccountDefaultCountry__c ="USA", AQB__AccountDefaultCountry__c ="United States", ISBLANK(AQB__AccountDefaultCountry__c)),
LEN( AQB__AccountDefaultCity__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", AQB__AccountDefaultStateProvince__c )
))

Error message

A valid two-letter state code is required.

Error location

Permanent Address State/Province