Link to home
Start Free TrialLog in
Avatar of titorober23
titorober23

asked on

radio button values

Hi Guys

I have a text field with a list value(4 choices), i was using a combo box, now i want to use radio buttons, so i created an option group and the buttons, but they only take numberic values, how can i change this so if anybody click on option 1, then a text is assign to my field, not  number.

Please advise
SOLUTION
Avatar of therealmongoose
therealmongoose
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
", then a text is assign to my field, not  number."

There is really no good reason to do this and it defeats the purpose and function of the Option Group.  Instead, populate your field with the option group number.  Then, whenever you need to display text related to the stored group value, you can use the Choose() function ... which is ideal for this purpose - as hnasr showed.

mx
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
So, you are no longer using an option group ?

mx
Avatar of titorober23
titorober23

ASKER

I am using an option group, it is just a change on the table level