June 14, 200124 yr Is it possibe to have a conditional value that if is true will change the Text style or colour. For example: If a date become more then 5 days old, the font colour would change to Red or the font would go bold. Can anyone save my *** ?
June 14, 200124 yr The only way I know is to use stacked fields. Two calculated fields that will if true = your other field otherwise blank, original field value = "6/13/01" 1st calc field: if condition is true = value from original field (set text color to your choice) 2nd calc field: if condition is false = value from original field (set color to your choice) so if the condition is true field 1 = 6/13/01 and field 2 = blank otherwise field 1 = blank and field 2 = 6/13/01. Stack the fields on top of each other and set the fill pattern to transparent.
Create an account or sign in to comment