Can you give combo box responses a numeric value?

[ptaylor-west]

I have a typical questionnaire with multiple responses using a combo box.

Response examples: Agree, Disagree, Strongly Disagree and so on.

Is it possible to give each response a numeric value.

It can be done with buttons using optionvalue, but I can't use them because of lack of space. I need the values to underline the responses in the combo box. So the answer shows the text response but in the table it also records a numeric value.

My output is using graphs, hence the need for a numeric value, also I can tehn export the data into a stats package for further analysis.

 

[ShiftyJaffa]

You can do this by changing your combo properties to:-

RowsourceType property = Value List
Rowsource = 1;Agree;2;Disagree;3;Strongly Disagree etc etc
Columns = 2
Column Widths = 0 (to hide the first column on the drop down)
Bound Column = 1

 

[ptaylor-west]

Spot on, many thanks.