Post reply

nested IIF for font color

  • July 30, 2013 at 3:02 pm

    #297023

    Hi

    I must have something missing unless I can't use IIF for font color?

    iif(ReportItems!Textbox26.Value >0, "Red",iif(ReportItems!Textbox26.Value < 0, "Green","Black")

    ))

    Thanks In Advance

    Joe

  • July 31, 2013 at 2:44 am

    #1637271

    You can use Iif in font colours.

    Are you formatting the text based on it's value (that is not on the value in a different textbox)? If so try using "Me.Value" in place of the ReportItems you are using.

  • July 31, 2013 at 7:52 am

    #1637391

    what are some of the values in that textbox? Sometimes I've had to use 0.0 in an iif instead of just 0.

  • July 31, 2013 at 9:55 am

    #1637451

    Don't forget the "=" sign at the front.

    Also, you might want to check the number of closing parentheses there 🙂

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply