Charlie Kilo Posted September 14, 2006 Share Posted September 14, 2006 (edited) 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, 2006 by Guest Link to comment Share on other sites More sharing options...
aldipalo Posted September 14, 2006 Share Posted September 14, 2006 Case(not IsEmpty(Name);Name;"Name" ; Name = "Name"; TextColor ("Name" ; RGB ( 255 ; 0 ; 0 )) ) HTH Link to comment Share on other sites More sharing options...
Charlie Kilo Posted September 18, 2006 Author Share Posted September 18, 2006 Thanks, mate. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6522 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now