How do I conditionally change color of data returned from a formula 4

[iwm]

My more experienced predecessor has created a formula using case logic. Unfortunately our client would like to change the form so that whenever the formula returns the words "data blank" they appear red while the rest of the formula results remain black.

Below is a segment of that formula:

select Left({RptPersonnelSP;1.optionName}, 3)
case "T13":
"13 (03) – Transferred to another State Agency" + chr(13) + "Agency: " + IIF ({RptPersonnelSP;1.cvAgencyTransferTo} = "", "data blank", {RptPersonnelSP;1.cvAgencyTransferTo}) + chr(13) + "Start Date: " + IIF ({RptPersonnelSPP;1.cvNewAgencyStart} = "Dec 30, 1899", "data blank", {RptPersonnelSP;1.cvNewAgencyStart}) + chr(13) + "*Letter of Resignation*"


When the formula returns the words "data blank" my client would like to see these words in red. Is it possible to change the color of one part of a formula while the rest remains the original color?
Your assistance in this matter is tremendously appreciated.

Thanks,
iwm

 

[Turkbear]

Hi,
You can format the field with a conditional color based on the contents - use the x*2 button next to the font color option and use something like

If "data blank" then colorRed else defaultColor

Not at a CR setup so check the help file on using this type of formula for font color.





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[chelseatech]

The conditional formula should say

If CurrentFieldValue="data blank" then colorRed else defaultColor

Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[Turkbear]

Hi,
good catch, I forgot that the test needed the field to compare to.





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[lbass]

Change the formula to:

select Left({RptPersonnelSP;1.optionName}, 3)
case "T13":
"13 (03) – Transferred to another State Agency" + chr(13) + "Agency: " + IIF ({RptPersonnelSP;1.cvAgencyTransferTo} = "", "<font color=red>data blank</font color>", {RptPersonnelSP;1.cvAgencyTransferTo}) + chr(13) + "Start Date: " + IIF ({RptPersonnelSPP;1.cvNewAgencyStart} = "Dec 30, 1899", "<font color=red>data blank</font color>", {RptPersonnelSP;1.cvNewAgencyStart}) + chr(13) + "*Letter of Resignation*"

Then format the formula to use HTML text interpretation (format field->paragraph->text interpretation->HTML text).

-LB

 

[iwm]

Ok,this is great! There just one problem. How do I do a carriage return when using html? I was using chr(13). Any suggestions?

Thank you so much!

Ingrid

 

[dunlop1975]

Been a while since I touched HTML, but I believe it's <BR>

 

[iwm]

Everyone,

On behalf of my career, I thank you!

With Great Appreciation,

Ingrid