Skip to Content

Text Object - Conditional Formatting

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Oct 16, 2015 at 12:59 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 16, 2015 at 12:48 PM

    Hi Gerald,

    On what condition would you like to change the color?

    What formula have you used for the font color?

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded