if you right click on a field, and select "text format" there is a drop down menu for color.

or

format > text color in the menu

------------------

Thank you. I am asking about during a script performance.

Mike, the only method I've been able to find to deal with formatting things like color is to create an overlay. Hopefully you are using a trigger field to determine the color and you don't have a huge number of diffent color or field involved, if so this should work.

Say you have a Person's name and you want it to be a certain color based on a status field. Let's say Active=Green, Pending=Yellow, and Inactive=Red. Create three calc fields, one for each of the status colors. Calc would be =If(Status = "Active", Name, "") The Name field would be the field the name was originally entered into. Take each of your calc fields and format them to the color you want, and overlay them over each other. Now when you select a status, or change it in a script, the appropriate color name will appear. I know it a little klugey, but, it does work.

HTH

Is there a function that can change a field's font color or does it have to be applescripted?

Just make sure the fields (except perhaps the one in the back) are all transparent.

The general method of changing the color of field or layout backgrounds is to use a calulated container field. Creating a repeating global container field (gContainer). Copy and paste rectangles filled with the appropriate color into gContainer (copy in Layout mode, paste in Browse mode). Create a calculated background field.

Background (calculation, container) =

Case (

Test 1, GetRepetition(gContainer, 1),

Test 2, GetRepetition(gContainer, 2),

Test 3, GetRepetition(gContainer, 3),

GetRepetition(gContainer, 4)

)

In layout mode place the field "Background" and format it to "Reduce or Enlarge" and uncheck "Maintain Original Proportions" box.

-bd