Can you create a script to change the format of a field...ie background color/pattern?

I want to be able to check a box and if its checked certain fields will become a different color.

thanks!

Unfortunately there is no "built-in" way to do this in FMP. The common way to handle this is to import a one-pixel image of the color you desire into a global field. Then, create a calculated container field that, if your criteria are met, is equal to that global field. Place that calculated field behind the main field in question and make the main field in question transparent.

A slightly more powerful version of the above suggestion involves a repeating container field (either global or normal placed in a Preferences DB) which contains swatches of various colors and/or other graphics. It then uses calculated "Background" fields to display a particular swatch based on the value in some other field.

For example:

cBackground = If ( Value1 = "Yes", GetRepetition ( gColorSwatches, 1 ), "" )

This will cause the background field to use the swatch in repetition one.

You could then have either a case statement in the cBackground field or use seperate background field for different criteria.

I tried the second method posted by Goldraven.. It does not seem to work! when the criteria is met I get a one pixel image in the calculated container field as opposed to the color filling the enitre container field..

What am i doing wrong..

Stu

what you need to do is right click on the container field, choose graphic format. then in the little drop down box, coose Enlarge image to fit frame.

That should do it.

Worked like a charm!

Thanks