I suggest that you make a table of states where the key field is the two letter state abbreviation. I'm going to assume that the record you're dealing with also have the state abbreviation code on them somewhere. I'm sure you can Google and find an Excel sheet or copy paste where you can quickly enter the 50 states.
Add a field to your states table for the URL website.
And make a relationship where one state has many of your records. Lookup the URL website field down to your details table. When the user selects a state, the lookup field will populate.
This is a much better approach than hard coding the websites in a long formula as this way the ongoing maintenance of the URLs is by data entry and not coding changes.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
