Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2002
    Posts
    173

    Unanswered: negative/positive numbers

    I have a calculated text box on a form and wish for negative numbers to simply appear as zero. All positive numbers can appear as normal. This field contains two decimal places. Is there a way to do this?

  2. #2
    Join Date
    Oct 2001
    Location
    Chicago
    Posts
    440
    Set the textbox contol source to:

    =IIf(YOUR_CALCULATION>0,YOUR_CALCULATION,0)

Posting Permissions

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