So (thanks to InkyPhil), I've got this calculation working on my FORENAME field:

[color:black]Case(not IsEmpty(forename);forename;"(forename)")

Great! But I'd also like FM to change the colour of the text if the value is ever "(forename)". Something like this might work:

[color:black]Case( forename = "(forename)"; TextColor ( forename ; RGB ( 255 ; 0 ; 0 )))

Can anyone tell me how I get both of these calculations working on the same field? I think it's expecting a boolean operator between them, but the & operator doesn't seem to work. (The colour doesn't change).

Edited September 14, 200619 yr by Guest

Case(not IsEmpty(Name);Name;"Name" ;

Name = "Name"; TextColor ("Name" ; RGB ( 255 ; 0 ; 0 ))

)

HTH

Thanks, mate.