Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Plus Sign For Positive Numbers

Discussion in 'Information Technology' started by charles.kendricks@charter.net, Jul 28, 2006.

  1. charles.kendricks@charter.net

    Guest

    Is there a way, in a report, to display positive number values (from an
    underlying number field in the source table) with a plus sign, just as
    negative numbers are? ...I'm sure there's a simple answer to this
    question.
     
  2. Loading...

    Similar Threads Forum Date
    Opinion Why Having Sikhs In The Military Is A Plus Sikh Sikhi Sikhism Jun 30, 2016
    Devanagari as a Writing System for Punjabi: Plus or Minus for Punjabi? Punjab, Punjabi, Punjabiyat Jul 30, 2013
    Opinion In Haiti, plus ça change ... Breaking News Jan 24, 2010
    World Please keep the 100,000+ departed, plus injured Haitian souls in your prayers ! Breaking News Jan 14, 2010
    Sikh News Punjab sure of procuring surplus milk, Haryana fears shortfall (Express India) Breaking News May 15, 2008

  3. Allen Browne

    Allen Browne
    Expand Collapse
    Guest

    Try setting the Format property of the text box on the report.

    Perhaps something like this:
    +#,##0.00;-#,##0.00;0.00

    --
    Allen Browne - Microsoft MVP. Perth, Western Australia.
    Tips for Access users - http://allenbrowne.com/tips.html
    Reply to group, rather than allenbrowne at mvps dot org.

    <charles.kendricks@charter.net> wrote in message
    news:1150023032.227782.112810@h76g2000cwa.googlegroups.com...
    > Is there a way, in a report, to display positive number values (from an
    > underlying number field in the source table) with a plus sign, just as
    > negative numbers are? ...I'm sure there's a simple answer to this
    > question.
     

Share This Page