Newbies supercram Posted July 7, 2005 Newbies Share Posted July 7, 2005 Hi all- Wondering if anyone had a thought on how I could make a field's color change based on evaluating another field. That is, if Field A is "1" then Field B turns green (in a specific layout). If Field A is "0", do nothing. Can't seem to find a function in either ScriptMaker or in the Calculation functions. I appreciate any advice. Link to comment Share on other sites More sharing options...
Søren Dyhr Posted July 7, 2005 Share Posted July 7, 2005 Thinks of mergefields showing the char "g" in a considerable fontsize, and use the textformatting functions to change accordingly... --sd Link to comment Share on other sites More sharing options...
sbg2 Posted July 7, 2005 Share Posted July 7, 2005 You cant change a fields BG color but you can fake it by making the fields BG color transparent and using a calculated container field behind the transparent field. See the following thread for a similar example. change BG Color Link to comment Share on other sites More sharing options...
sbg2 Posted July 7, 2005 Share Posted July 7, 2005 Thinks of mergefields showing the char "g" in a considerable fontsize, and use the textformatting functions to change accordingly...--sd I have used the Arial character "Full Block" U+2588 with good results. It is a pain to resize the field and change font size though, needs a lot of tweaking through trial and error. Example shown below is form a List View layout and uses a calculation field = If(Mod(Get ( RecordNumber );2) > 0; TextColor (g_BG_Character ; RGB (200 ;208 ; 200 ) ); TextColor (g_BG_Character ; RGB (200 ;200 ; 208 ) )) Link to comment Share on other sites More sharing options...
Newbies supercram Posted July 7, 2005 Author Newbies Share Posted July 7, 2005 Thanks. The download example will probably work for me, once I reverse engineer it. Thanks again! Link to comment Share on other sites More sharing options...
Søren Dyhr Posted July 8, 2005 Share Posted July 8, 2005 I have used the Arial character "Full Block" U+2588 with good results. Ups! forgot to mention that I use "g" from the webdingsfont ... --sd Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7002 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