Hi all-

Wondering if anyone had a thought on how I could make a field's color change based on evaluating another field.

That is, if Field A is "1" then Field B turns green (in a specific layout). If Field A is "0", do nothing. Can't seem to find a function in either ScriptMaker or in the Calculation functions.

I appreciate any advice.

Thinks of mergefields showing the char "g" in a considerable fontsize, and use the textformatting functions to change accordingly...

--sd

You cant change a fields BG color but you can fake it by making the fields BG color transparent and using a calculated container field behind the transparent field. See the following thread for a similar example.

change BG Color

Thinks of mergefields showing the char "g" in a considerable fontsize, and use the textformatting functions to change accordingly...--sd

I have used the Arial character "Full Block" U+2588 with good results. It is a pain to resize the field and change font size though, needs a lot of tweaking through trial and error. Example shown below is form a List View layout and uses a calculation field = If(Mod(Get ( RecordNumber );2) > 0; TextColor (g_BG_Character ; RGB (200 ;208 ; 200 ) ); TextColor (g_BG_Character ; RGB (200 ;200 ; 208 ) ))

Thanks. The download example will probably work for me, once I reverse engineer it.

Thanks again!

I have used the Arial character "Full Block" U+2588 with good results.

Ups! forgot to mention that I use "g" from the webdingsfont ...

--sd