Is there any way to add multiple colours to a value list. I am trying to create a list shoing project status (Active, Pending, Inactive, Prospect) and would like to have the colours Green, Yellow, Red and Purple respectively.

To date I have overlaid coloured text over the list but depending on the operating system I have seen it shift plus it would be cleaner if I could do it without the overlay.

I appreciate any help you can provide and am very appreciative that a forum like this exists as I've been using FM from back in the Claris days of version 1 and am now migrating (from scratch) to 8 ... ugghhh

Dante,

If I understand your question correctly, you should be able to conditionally format the text color for your value list.

Select "OPTIONS" when presented the define fields dialog box.

Select "Calculated Value"

Select "Specify"

Enter the following calculation:

Case ( Status = "Active" ;

TextColor ( Status ; RGB ( 51; 102 ; 51) );

Case ( Status = "Pending" ;

TextColor ( Status ; RGB ( 255 ;255 ; 51) );

Case ( Status = "Inactive" ;

TextColor ( Status ; RGB ( 255 ; 0 ; 0) );

Case ( Status = "Prospect" ;

TextColor ( Status ; RGB ( 102 ; 51 ; 255) );

TextColor ( Status ; RGB ( 10 ; 10 ; 10) )

))))

This should get your green, red, yellow, purple text when the respective value is selected from the valuelist.

In the case that none of these options are selected, the text should be black.

I think I got the RGB colors right.

You can easily find and download an RGB color chart to fix it if I got it wrong.

Hope this helps,

Jarvis

Hi Jarvis,

Thank you for the reply. You definitely solved part of my problem which is great; but not all of it. (My fault for being vague).

In my case the Value list is presented as a radio button list and so therefore, before you've selected anything, it's sitting there with the radio buttons to the left and the text to the right. I am wondering if you can make the text to the right different colours before a selection is made?

That said, you have solved something else that I was using an old work around to solve and your method is nice and clean!

Cheers

D.

You would probably do better by using your own buttons, instead of a field with radio buttons.