Changing Color Of Text Based Upon Datasource Value

[skuhlman]

One of the fields in my data source contains one of the basic 15 colors used in the color dialog boxes (ie RED, BLACK, LIME, NAVY, SILVER...). I would like to just put the field in the color dialog box like:

{MyDataSource.MyColorField}

Since I can put "RED" in the conditional formating box and it changes the text to red, I would expect this to work, however the editor thinks that the "formula" must result in a number and a value of 'RED' in the field apparently isn't concidered a number.

Is there an easy way to "evaluate" the contents of my field instead of having to write a big if statement to handle all of the possible colors?

Thanks in advance.

 

[synapsevampire]

I'm afraid not, it's the age oldpain that you can't transpose values to syntax in Crystal.

-k