I am working on a form and it's been a long while but I have a sreadsheet with over 1000 items listed that I want to use to populate a drop down list. I only see a way to add one item at a time. What am I missing?
you can paste all items at once into a drop down.
Open you spreadsheet in Excel and select the desired cells.
Press Ctrl + C to copy the contens to the clipboard.
Now select your dropdown box in Designer and click the "Paste from clipboard" icon in the field palette (right above the list with the elements).