Newbies dante_in_calgary Posted February 28, 2006 Newbies Posted February 28, 2006 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
Jarvis Posted February 28, 2006 Posted February 28, 2006 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
Newbies dante_in_calgary Posted February 28, 2006 Author Newbies Posted February 28, 2006 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.
comment Posted March 1, 2006 Posted March 1, 2006 You would probably do better by using your own buttons, instead of a field with radio buttons.
Recommended Posts
This topic is 6862 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now