Heathbo Posted October 8, 2005 Posted October 8, 2005 I need a calculation field that is supposed to change its text color if the text color of another field is white. I'm not quite sure how to do this. This doesn't seem to work: Case (TextColor ( Att15 ; RGB ( 255 ; 255 ; 255 ) ) ; TextColor ( Att15 Card ; RGB ( 255 ; 255 ; 255 ) ) Plus I also need this calculation in this field. Att15 + PAtt Container I'm not sure how to make the first calculation work, and I don't know how to combine the two calculations. Any help you can give is much appreciated.
Ocean West Posted October 8, 2005 Posted October 8, 2005 How about this... Case ( PatternCount ( GetAsSVG ( field ) ; "#FFFFFF" ) ; TextColor ( field ; RGB ( 0 ; 0 ; 0 ) ) ; TextColor ( field ; RGB ( 170 ; 0 ; 0 ) ) ) if the field has any White text it will be formatted to black if there is no white text it will be formatted red.
Heathbo Posted October 9, 2005 Author Posted October 9, 2005 How would this work? What I need is to check to see if the color of the text in the Att15 field is white. If it is, I need to change the color of the text in the Att15 Card field to white.
-Queue- Posted October 10, 2005 Posted October 10, 2005 Make Att15 Card an auto-enter calculation, with 'do not replace existing value' deselected, of TextColor( Att15 Card; Case( PatternCount( GetAsSVG(Att15); "#FFFFFF" ); 16777215; 11141120 ) ) replacing 11141120 for the RGB of the color you want as the default.
Recommended Posts
This topic is 7082 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