Is it possible to change the colour of a field based on its contents

RED - no

GREEN - yes

ORANGE - anything else

?

Any ideas would be useful

Thanks

Simon

If you have FM 7 this works.

Code=?? "TextColor(YourField;(Code=??)*RGB(150,0,0)"

RGB(150,0,0)=Red

RGB(0,150,0)=Green

RGB(0,0,150)=Blue

Nope not using FM7 yet still on FM6

Then you need a new calculation field for every color and for every colorchanging field. Make them transparent, format the text with the colour you need and place it above the original field. The calculation would be something like, for example for the red one: Case( field=Red; field;""). The fields will only show, if there's text in it, will say if the equation turns true.

Hi Simon,

If I understand you correctly, here are some example files of what you are wanting to do. Three of which are available here in the Forum.

"Colored Fields" By John Mark Osborne Available At

http://www.databasepros.com

"Color Calc" By Don Wieland Available At

http://www.dwdataconcepts.com

"Color Menus" By Aschol Available At

http://www.fmforums.com/threads/showflat.php?Cat=0&Number=47663

"background Color" By CobaltSky aka Ray J. Cologon Available At

http://www.fmforums.com/threads/showflat.php?Cat=0&Number=48837

"Field Background Color Change" By Chopper aka Robert T. Schaub Available At

http://www.fmforums.com/threads/showflat.php?Cat=&Board=files&Number=85619

HTH

Lee

Hi

I am an unexperienced user of FileMaker Pro 6

Using Case I want to show the words for 'Distinction','Merit','Pass','Fail' in different colours.

Fail - Red

Pass - Green

Merit - Blue

Distinction - Orange

Pryesh

Hi Pryesh,

If I'm understanding you correctly, you want your calulation field, to be populated based on the data in another field.

To start with, make sure your first field is text. For the purpose my explaination, I'll call it FieldA, and I would attach a value list to it with your action words of:

Fail

Pass

Merit

Distinction

Create your calculation field, I'll call it Field B here

FieldB, a Calculation, with a Text Result =

Case(FieldA="Fail", "Red",

FieldA = "Pass", "Green",

FieldA = "Merit", "Blue",

FieldA = "Distinction", "Orange")

If this isn't what you had in mind, come back and let me know.

HTH

Lee