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

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


      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:



      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.