Radio button to change color in another field?

[splodgehodge]

Hi,

It seems an easy task but I've been going around in circles!!

I have a radio button with "yes","no" and "working towards"(WT)

I would like the text color to change in another field if yes, no or wt is pressed.(I'm using fm10)

Thanks all.

[LaRetta]

Attach conditional formatting lines to that other field, such as:

Formula is ... table::RadioButton = "Yes" ... and below select text color blue

then add new condition

Formula is ... table::RadioButton = "WT" ... and below select text color green

etc. Replace RadioButton with your true field name of course. :wink2:

[Raybaudi]

I'm assuming that you have more than 3 values for your radio button field and that the color of your other text field must change ONLY when one ( or more ) of those 3 values are choosed.

Use the conditional formatting for that field with this calculation:

ValueCount ( FilterValues ( YourRadioButtonField ; "yes¶no¶wt" ) )

[splodgehodge]

Excellent, thanks for that.

Its all working.