Coloured Text??

[Lucky]

Is it possible to show different colour text depending on what item I choose in a field with a value list. ie: Field name is Delivery and if I choose "TNT 9" from the pull down menu I would like this to appear as red text but If I choose "TNT 10" I need in blue.

Any ideas?

[RalphL]

You will need a calculated field for each value. Red = If (Delevery = "TNT 9", "TNT 9", "") and Blue = If (Delevery = "TNT 10", "TNT 10", "") You can stack these fields on top of each other. Or you can use merge fields <<Red>><<Blue>> Make the <<Red>> red text color and <<Blue>> blue text color.

[-Queue-]

You can also use Case and remove the false "" result.

[Lucky]

Thanks for the reply. I have used this:

Red =

If(Delivery="TNT 9","TNT 9", If(Delivery="TNT 10","TNT 10", If(Delivery="TNT SAT","TNT SAT",Blue)))

The problem I now have is that I have Edit value list selected so I can add special delivery's if they need it. How do I get them to appear in Blue.? I cannot set a calc as above because I do not no what the special delivery will be.

[Lucky]

It's Ok I think it works now:

Red =

If(Delivery="TNT 9","TNT 9", If(Delivery="TNT 10","TNT 10", If(Delivery="TNT SAT","TNT SAT",Blue)))

Blue =

If(Delivery="TNT 9","", If(Delivery="TNT 10","", If(Delivery="TNT SAT","",Delivery)))

Thank you for your help.

[-Queue-]

If I'm understanding this correctly, you could simplify it to

Red =

Case( PatternCount( "TNT 9TNT 10TNT SAT", Delivery ), Delivery )

Blue =

Case( IsEmpty(Red), Delivery )