on 10-16-2015 1:36 PM
Hello,
I have inserted two text boxes in my document that I would like to have conditional formatting. If a fieldname in my database equals to something then I want to have the textbox font color to change. I have it working for my background, but I don't see it for the font color itself.
Or even if I can have my text box hide and unhide if the conditional is meet also for the fieldname.
I tried to search for this online and came up empty handed. If anyone can help I would appreciated it.
Thank you,
Gerald
Hi Gerald,
As per my knowledge, we can Hide/ Show the text boxes based on a condition but there is no option for change font color dynamically for a Text box.
To show/hide your text box, then right click on the text box in suppress formula editor write your logic..
OR You can achieve this using HTML Text
if {database_field} = Condition then
"<p><b><font color='#00559c'>" & [Data] & "</font></b></p>"
Else
"<p><b><font color='#00559c'>" & [Data] & "</font></b></p>"
OR use formula instead of Text box and then right click on the Formula filed > font tab> color [X-2], write your logic here.
--Praveen G
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
As Praveen said, you don't get that option for Text Objects.
Here's the workaround:
1) Remove the database field from the text object
2) Drag and drop the database field on one of the sections > Right-click and select Format Field > Font tab > Click the formula button beside 'Color' > Type in the conditional color formula you have for the Font Color
3) Drag and drop this formatted database field inside the Text Object (that is formatted to conditionally color the background)
-Abhilash
Hi Gerald,
On what condition would you like to change the color?
What formula have you used for the font color?
-Abhilash
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.