Interspire: Solving the “State/Province required” error in Internet Explorer when creating new accounts

I recently helped a customer who was not able to set up an account on an Interspire store in Internet Explorer because the field for selecting a state/province was not displaying, so he could not select the correct one, and yet it was a required field – so he could not create an account. Here is how I solved the issue:

1) Make the “State/Province” field NOT required

Log into the PHPMyAdmin for the Interspire site and open the formfields table. In the formfieldlabel column, you will see two entries for “State/Province.” Open each one, and change the value for formfieldisrequired and formfieldisimmutable from 1 to 0. Save your changes. This makes the “State/Province” field an optional field and not a required field anymore.

2) Make sure the “State/Province” field is displaying in Internet Explorer

In looking at the source code of the Create Account page, this is the html for the State/Province field:

<select name="FormField&#91;2&#93;&#91;12&#93;" id="FormField_12" style="display: none; ">

As you can see, the style “display:none” was being added to the field. In order to fix this, I added this block of code to the stylesheet for the site:

#FormField_12 {
display:block !important;
}

Note: You may need to change the ID for the code block above if it is different than the ID in your Create Account page.

Save your changes, refresh the page in Internet Explorer and – Voilà! Now customers can both see the State/Province and not fill it out if it is not relevant to them.