Change text color FileMaker Pro 8.5


  I am trying to accomplish a very simple task that FMPro is making much too complex.

  I want to compare two fields (as I already do with an If statement) and when one is <= the other I want to change one of the fields' text color to red.  

  I have the comparison in an If statement already, and I understand that I need to use the TextColor function.  As I cannot type this function in nor put it under the if statement as a result of the comparison, I am unsure of where to go from here.  

  Any help is GREATLY appreciated.
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Will LovingPresidentCommented:
You'll need to create a third field (I'll call it Field1_Display) as a calculation and put it in place of the field whose text you want to have change color, or if you need the user to be able to edit the original field, layer it on top of the editable field.

If Field1 is the field you want to have change color, the calculation will be:

Field1_Display =

   Field1 <= Field2 ;
   TextColor( Field1 ; RGB( 255; 0; 0 ) ; Field1

If you choose to layer the calc field on top of the actual field, just make sure to uncheck "Browse" access in the Field Entry options.

In FileMaker Pro 10 and later you can avoid creating an additional field by using "Conditional Formatting". This allows you to change the appear of a single field based on whatever calculation you wish. Just select the field, choose "Conditional Formatting" from the Format menu or by right-clicking (Control-click on a Mac) and then enter just the comparison part of the above calculation and set the color to Red in the Conditional Formatting dialog. The text will change color if the conditions are met and you can add other changes like Bold as well.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
FileMaker Pro

From novice to tech pro — start learning today.