Row source values to be shown as text - possible?

[aat]

Hi,

I would like my combo list to show text options ("1","2-5",">5") but I would like this text to be translated into figures into my table (respectively 0, 0.5 and 1). I do not want the user to see the figure as it would be confusing. Can I configure this in my combo list parameters, so that when the user select ">5", it translates into my table as 1?

thank you

Aat

[June7]

Yes. This can be done by either having a table of these values or a Value List as the RowSource.

RowSource: 0;1;0.5;2-5;1;>5
RowSourceType: Value List
ColumnCount: 2
ColumnWidths: 0";0.25"
BoundColumn: 1

[aat]

cool, tested, works! thanks
aat