Results 1 to 4 of 4

Thread: Negativ umvers in other Color

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Join Date
    Nov 2011
    Location
    Germany Hamburg
    Posts
    215

    Default Negativ umvers in other Color

    Hi,

    How can I display negative numbers in red?

    Ralf

  2. #2
    Join Date
    Feb 2009
    Location
    Hengelo, Netherlands
    Posts
    10,869

    Default Re: Negativ umvers in other Color

    Ralf,

    Each object has field properties. Many objects have a font or color tab-page. You can create a function returning a red color when the value is negative.
    Regards,
    Data Access Worldwide
    Vincent Oorsprong

  3. #3
    Join Date
    Feb 2009
    Location
    Somewhere in Vermont, USA - unless I'm not
    Posts
    11,085

    Default Re: Negativ umvers in other Color

    Go to Field Properties, Font Tab, and click on the formula button for Color.

    In the editor (use your fieldname!):

    Code:
    if {PostingLines.ITax} < 0 then 
        return drRed
    else
        return drBlack
    end
    Garret

    Time for an oldie but goodie:

    "If it ain't broke, you're not trying." - Red Green

  4. #4
    Join Date
    Nov 2011
    Location
    Germany Hamburg
    Posts
    215

    Default Re: Negativ umvers in other Color

    That's what i need
    thanks
    Ralf

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •