I already know how to populate a list, thanks though. This is about populating the VALUES as shown and stated above. If you have your text on the clipboard and you click the Specify Item Values box, it pastes tham all in, but it makes the values start at 1 and go to however many there are. I need it to paste as shown with the Text matching the Text in the drop down list, and the values I need in the Value column. Which are the comma delimited values for me to use to split them into different fields.
As I said and as it shows, I was able to do it before, but it was only once and quite a while ago, and I just can't remember what I did to get the results shown.
If the Clip board has copied one column(ex: excel sheet) it will copy all the rows as values "Text" of the drop down ONLY.
If the Clip board has copied 2 columns the first column goes in to "Text" and the second column goes into"Value". By default the it will be checked the "Specify item values" check box too.
All you need here is:
1.format text and values in to 2 separate columns to populate the dropdown. (can use excel features to generate the spreadsheet. This step output should be in 2 columns only to go in to text and values of DD).
2. place a dropdown field (no properties changes required on any TAB(ex: binding))
3. copy the 2 columns from the spreadsheet and paste it using the "paste from clipboard" under "Field" tab
4. now check the binding tab, should be there both values and text for all the entries provided by spread sheet.
Hope this helps, If i understand incorrectly please ignore this.
OK, that's what I was missing! That I needed the multiple columns to be copied and pasted from the clipboard. Thank you very much, hopefully it is now etched into my brain!