Welcome to Forums Sign in | Join | Help | Forums
in Search


Conditional Font Formatting

Last post 02-09-2010 12:22 PM by Liza Rosen. 4 replies.
Page 1 of 1 (5 items)
Sort Posts: Previous Next
  • 02-08-2010 4:41 PM

    Conditional Font Formatting

    I would like to format the address fields to be Italic, when a certain condition is met in a separate field that is textual. I am trying to do a formula for the font attribute Italics, and it is telling me that the formula has to equal a number. Is it true that you can't do conditional formatting based on a text field? Only numerical fields?

  • 02-08-2010 4:59 PM In reply to

    • Patrick Manning
    • Top 200 Contributor
    • User Since: 1997
    • Posts 45
    • Organization: College of Charleston
    • Products:  The Raiser's Edge

    Re: Conditional Font Formatting

    Is it a text or string field?  You can do it for a string field.  For example:

    if {Raisers Edge.City} = "Chicago" then "Arial" else "Times New Roman (Western)"

    Patrick Manning
    Database Administrator
    Advancement Services
    College of Charleston
  • 02-09-2010 11:25 AM In reply to

    Re: Conditional Font Formatting

    Hmmmmn, something is weird. If I create a formula for a specific field, the example you gave is fine. But, if I try to apply conditional formatting to this field, it tells me that the "formula result must be a number".

     So, for example, I'm trying to set the {Address Line 1} field to be Italic, only when a separate field is "Lost Address".

     No idea!

  • 02-09-2010 11:45 AM In reply to

    • Yuriy Iordakiev
    • Top 75 Contributor
    • User Since: 2000
    • Posts 99
    • Organization: Trillium Health Centre Foundation
    • Products:  Blackbaud NetCommunity, The Raiser's Edge

    Re: Conditional Font Formatting

    if {DONOR_WA.Name}="Company Name" then crBolditalic

    Constant Description

    crRegular

    Format font in regular type face.

    crBold

    Format font in bold type face.

    crItalic

    Format font in italic type face.

    crBoldItalic

    Format font in bold italic type face.

  • 02-09-2010 12:22 PM In reply to

    Re: Conditional Font Formatting

    Thanks so much that worked!

Page 1 of 1 (5 items)