2 Replies Latest reply on Sep 21, 2011 12:56 PM by dbroeker47

    How do I fix this error?     $1.#R

    dbroeker47

      A customer of mine said he kept getting a calculated error of    $1.#R   in the results field on our on-line order form.  I checked it out and the field will accept any total up to $999.99 correctly, but gives the error shown directly below when the order total exceeds $999.99.  This would mostly happen in the GRAND TOTAL field.

       

      Here is the error reported:

      Warning: JavaScript Window -

      The value entered does not match the format of the field [ N41GT ]

       

      Note that field N41GT is the Grand Total amount owed.

       

      This order form can be downloaded at this link:

      https://acrobat.com/app.html#d=KiHIpb8n*KM*Zkkx4KdTjg

       

      Until I can fix this, my customers with large orders have to send me multiple order forms to place their orders, or print out the on-line order form and fill it out by hand.

       

      Here is the validation script:

       

      if(event.value == 0) {

      event.value = ""; // null the value

      AFNumber_Format(2, 0, 0, 0, "", true); // reset format to number only;

      } else {

      AFNumber_Format(2, 0, 0, 0, "$", true); // use currency symbol;

      }

       

      Your assistance is greatly appreciated.