Corey Martin Posted June 27, 2003 Posted June 27, 2003 I have a number field. I'm trying to use a script to change the field font to Red and Bold if the value is under 220. Of course this wouldn't affect the actual data in the field, just the appearence of it. I know how to evaluate the value but not how to change the font color and style of the field. How would I do this? Thanks! Corey Martin
Lee Smith Posted June 27, 2003 Posted June 27, 2003 The easiest way to do this is to create a couple of calculation fields that are based on your current number field. You place one on top of the other and have the calculation show or be blank based on your number field. The attach file is a quick demo of this. HTH Lee ChangeTextColor.fp5.zip
Corey Martin Posted June 27, 2003 Author Posted June 27, 2003 Thanks for your reply and example. It does work, but there is one problem. Users have to be able to change the number. If I stacked two calculation fields on top of eachother to provide the effect of changing colors based on the number value, the user wouldn't be able to change either field. Is there a way around this? Thanks, Corey Martin
Lee Smith Posted June 27, 2003 Posted June 27, 2003 Just change the fill for the field "Red" to White, and then stack all three (i.e. align center /center) This will make it do what you want. Lee
Recommended Posts
This topic is 7824 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