I was updating an older form to use the null field type. I copied the new list of ESRI Field Types to this older form's type sheet. In my survey the drop down no longer works for this field. How can I fix it?
Update: I figured out that I needed to reset the range in the data validation for that column of cells.
Select one of the cells in the column for bind::esri:fieldType
From the Data tab in Excel, Data Tools on the ribbon, click Data Validation...Data Validation. Click on the up arrow on Source. Excel will take you to the types worksheet. Select the new range. Click on the down arrow. Excel will take you back to this screen. Click on the By checking "Apply these changes to other cells with the same settings" it will apply this to all rows in the column.
My dropdown works again and all of the choices are visible.
I used this opportunity to sort these drop down lists alphabetically.