I need to change the color of a field called "player" case a field called "captain" is Yes. In the "player" field i'm using this calculation:

Case(capitao = "true"; TextColor ( jogador ; RGB ( 100 ; 0 ;0 ) ))

I guess something is wrong..can anybody help me? =/

Does this work for you:

Case(capitao = "Yes"; TextColor ( jogador ; RGB ( 100 ; 0 ;0 )); TextColor ( jogador ; RGB ( 0 ; 0 ;0 ) ))

Hi Carlos,

If the field is "Yes", your calculation will not work with it "True"

Lee

Thanks for your response Lee. Sorry, i meant to write true. I tried to do as sbg2 said, but it didn't work. =/

If the field "player" is a text field with the option of AutoEnter a value based on that calculation, be sure to uncheck the box; " Don't Replace..."

I unchecked the box, but it still doesn't change the color. What i want to do is make some difference between the capitan and the other players, i can try something else, like bold or something (since changing the color isn't working). Does anybody know how I can do this?

Hi Carlos

can you post your file ?

Example of color change attached. user = Admin, no password.

Captain.zip

eheh it worked now! Thanks a lot for your help, I really appreciate it!