Dear All

I am sure that this has been posted before in the past so my appologies if it has but I have created a field that performs a calculation if the outcome of this calculation is greater than zero I would like the text to change colour.

Please help.....if this is not possible in defining a field I am equally happy to write a script to do this but I do not know how to change colour via a calulation.

Thanks in advance for any help

Create a global container field (call it "color holder", insert the color you want here.) Create a calc field be sure its a container calc. Case(your field >0,color holder,"") Then take your calc field and put it behind your field (be sure your field is transparent) then whenever your field is >0 the calc field will change color.

Hope this gives you an idea.

Dean

Hi SMcGoo,

Go to layout mode, select the field (it has to be a number or a calculation that results as a number to work), go to Menu - Format - Number. You can then select a color for negative numbers.

HTH

Lee

Go to the Samples section of this forum and download the latest version of the file under the "Handy Bits" title. It contains examples of changing text colour and background colour depending on field values.