Avatar

Level 4

Sorry about that...

The only other way I know of is to edit the xml directly. Add a list box or drop down list to your form. Select the field, then click the XML Source tab (next to master pages tab. If it's not there, right click to the right of the preview tab in the gray area and check off XML Source).

XML1.png

Where it says <items save="1" /> you can manually add in items in the following format:

<items save="1">

     <text>Option 1</text>

     <text>Option 2</text>

</items>

you can paste all of your list items into column A in an excel sheet, then put the following formula into B1 and fill down for the length of your entire list:

="<text>"&A1&"</text>"

copy all of column B for a list like:

<text>Option 1</text> 

<text>Option 2</text>

you can then directly paste that into the xml.

User beware, editing the XMl incorreclty can destroy your form. Always backup before you fiddle with xml.

- Scott

Edit: It may be easier to add one item to the list before opening the xml source. This will add the:

<items save="1">

     <text>your manually added value</text>

</items>

to the xml, allowing you to overwrite the "<text>your manually added value</text>" with your list from excel.