if MEMBERS::Group field contains "3 Chamber Singers" I want the text in MEMBERS::NamesForLabels to change color to purple. If MEMBERS::Group contains 'any else' I want the text to default to black.
You want to use a feature called Conditional Formatting.
In layout, select the field MEMBERS::NamesForLabels
Go to Format > Conditional...
The rest should be self-explanatory but reply if you need more help...
Thanks for the post. I tried the conditional format first. It doesn’t seem to work (or I don’t know how) getting its cue from a different field. I could only get conditional to work on the ‘chosen’ field.
Select "Formula is" and then your formula should be
MEMBERS::Group = "3 Chamber Singers"
Thanks - that worked - my problem is/was; I am new enough to Filemaker that I didn’t know you don’t use an IF statement of CASE statement in Conditional Formatting.
Come to think of it, that is my next question - can you put in the formula ‘IF’ or ‘case’? MEMBERS::Group has 6 possible answers and I would like to effect all 6 in different ways.
am I too full of questions?
Since each value is a different color, if I understand correctly, you would add a different conditional format for each value and color.
If the combination of values and colors are something that changes frequently, you may need to use a different method.
Each condition in conditional formatting can only have one set of formatting settings.
You CAN use If or Case in a conditional formatting formula, but the only thing that matters is whether the result of the calculation is TRUE or FALSE when converted to boolean.
For example, all of these calculations have the same boolean "truth" value:
If ( MEMBERS::Group = "3 Chamber Singers" ; True ; False )
If ( MEMBERS::Group = "3 Chamber Singers" ; 1 ; 0 )
If you want to check for multiple values in the field and display different formatting for each, you just need to add new conditions in the Conditional Formatting dialog, each with its own formula.
Note that text color can be produced via calculation using the function of the same name. I'd use a conditional format if the values such as "3 chamber singers" don't change or change very rarely, but might consider a set up with a related table of RGB values and these text values if these are something that will change from time to time because you can then update the table as needed instead of tracking down the places where you've set up this conditional format in order to update them. (this is especially a problem if you have multiple layout objects or layouts where you need this color or if the text that you want to change color is only part of the text in the field.)
This other approach is more complex to set up initially, so YMMV (your mileage may vary).
Retrieving data ...