I was looking through the scripts and functions and was surprised that I cannot set the color boundary or background of a field.

Is this correct?

You can change evrything else, like the size, type or style of a field.

Thanks for any tips or directions.

Using functions in field calculations or using scripts that use those functions, you can change the formatting (color, style, font, etc) of text in a field, but you can't change the size of a field nor its background or border color...directly.

You can use other fields to accomplish some of this though. You can create a calculated container field that when certain conditions are met, return a picture (which could be 1 pixel of a color). Place that field behind the field who's background you want to colorize, and voila!

David, thanks!

I had thought of something similar but your mental nudge gave me an idea. As you probably guessed, the fields that I am asking about are number based and cannot have their text colored.

But I like the idea of a field as 'indicator'.

I don't believe the fields being of type number should prevent you from using Text Formatting functions. You can use Auto Enter Calculations if a field type of calculation is impractical.

For instance in the Auto Enter options in the Field Definitions dialg..

NumberField = TextColor( NumberFIeld ; RGB ( 255;0;0))

Select the option to Alway Replace and you've got Red numbers, If you want to apply a test...

NumberField =

Case(

NumberField > 100; TextColor( NumberFIeld ; RGB ( 255;0;0));

TextColorRemove(NumberFIeld)

)

You've got red numbers when the value is 101+, non-colored numbers otherwise.

Is there a font that has a transparent background? I have a screen which layers buttons over some text, but it doesnt work with IWP because the button layer is transparent. My idea was to make the button layer have a fill color and make the text layer have transparent background as a workaround. Is there a font in FMP that has a transparent background? OR is there a way to dynamically set the text on a button with a script?

TIA,

Barb

Edited July 10, 200718 yr by Guest