jasemilly Posted May 26, 2011 Share Posted May 26, 2011 Hi everyoneI have a calculated field and if the value it contains is <=0 I would like the actual text box colour to be red how do I do this? thanksJasemilly Link to comment Share on other sites More sharing options...
jpauze Posted May 26, 2011 Share Posted May 26, 2011 There are a number of threads on here to deal with Conditional Formatting, as a guide, check out the help documentation on Conditional Styles or search the formum for the same, the documentation is pretty comprehensive on the subject. Basically you create a Conditional Style with the expression you are looking for and the color style you want, then you assign the style to your text element and voila, when the expression evaluates to true the style kicks in and overrides. ThanksJeff Link to comment Share on other sites More sharing options...
jasemilly Posted May 27, 2011 Author Share Posted May 27, 2011 I have the styles working showing if a value is good or bad. But I have a rectangle box across the width of the detail band this alternates between green and white just a nice banding effect.But the field no longer allows the colour underneath to come through I have played with the opaque tick box but to no difference. I only want the field to be red otherwise I want it to be the colour of rectangle box beneath. thanksJasemilly Link to comment Share on other sites More sharing options...
Recommended Posts
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