Report Rich Text Box if field < 0 then font color change

[evola1327]

I have a report with a rich text box - see sample below;

="For Work performed Contractor has been paid " & "<u><b>" & Format([PaidtoDate],"Currency") & "</u></b> " & " (“Payment”) and " & "<u><b>" & Format([Outstanding],"Currency") & "</u></b> " & " remains (including taxes and freight) to be paid under the terms of the Agreement for work to be performed."

If the [Outstanding] field is less than 0 I want the font color to be red otherwise black, bold and underlined as noted.

[DJRhino1175]

Have you tried using conditional Formatting?

[evola1327]

I tried conditional formatting and it changes everything within the rich text box to red

[NeoPa]

Evola1327:
I tried conditional formatting and it changes everything within the rich text box to red

According to your original question that's what you were after.

If the only part you want to be red is the currency value part of the whole value then you may try something that includes the RTF code for red in your Format() call :

... & Format([Outstanding],IIf([Outstanding]<0,'<color=red>Currency</color>','Currency')) & ...

I'm afraid I wouldn't know how to set a colour within RTF but the concept's there.