ContributionsMost RecentMost LikesSolutionsRe: Converting state address field into two letter abbreviationThanks guys, very helpful. I ended up converting the state/region to upper and used Contains within an IF. Maybe that's possible with Case but I couldn't seem to get it to work. If ( Contains(Upper([Ship To: State/Region]),"ALABAMA"), "AL", Contains(Upper([Ship To: State/Region]),"ALASKA"), "AK", Contains(Upper([Ship To: State/Region]),"ARIZONA"), "AZ", Contains(Upper([Ship To: State/Region]),"ARKANSAS"), "AR",.........etc.Re: How to make a button return to the same place on the page.Thanks for your response. It must be something browser related. I have set the same button up on another table and that one works fine in chrome but this one does not. The current button and anchor setup works in IE but not Chrome. So, anchors do seem to work in "a=er".Re: How to make a button return to the same place on the page.I am doing this but for some reason, it goes to the anchor, then it jumps back up to the top of the page. Any idea why? Formula - URL: URLRoot() & "db/" & Dbid() & "?a=API_EditRecord&apptoken=xxxxxxxxxxxxxxxxxxx&rid=" & URLEncode ([Record ID#])&"&_fid_88=" & URLEncode ([Location - Address: Street 1])& "&_fid_89=" & URLEncode ([Location - Address: Street 2])& "&_fid_90=" & URLEncode ([Location - Address: City])& "&_fid_91=" & URLEncode ([Location - Address: State/Region])& "&_fid_92=" & URLEncode ([Location - Address: Postal Code])& "&_fid_93=" & URLEncode ([Location - Address: Country])& "&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=er&rid=" & [Record ID#] & "#Anchor2")