Arithmetic Overflow Error

[BJS]

I am displaying the result of a calculation in a textbox on a form.

When doing the following math:

9999999999* 9999999999 =
I get error: "Arithmetic Operation Resulted in Overflow"

How can I handle this error and display the result: 99999999998000000001

Note: my numbers are dimensioned as "double" and I am using Mile-O-Phile's terrific function (which really helped me out with my number formatting issue) to display the result with 8 digits. (if you would like, see my other post that Mile-O-Phile helped me with: "display number with 8 digits"

I look forward to some help resolving this arithmetic error.

BJS

 

[dcx693]

Is the textbox bound? And if so, what is the data format of the field to which it is bound?

Access can "only" handle (I believe) 15 digits of precision. It will convert numbers past 15 digits to be zero. So 9999999999* 9999999999 will be converted to: 9.999999998E+19. The 1 at the very end of 99999999998000000001 would be the 20th digit of significance.

 

[BJS]

Is the textbox bound? And if so, what is the data format of the field to which it is bound?

Access can "only" handle (I believe) 15 digits of precision. It will convert numbers past 15 digits to be zero. So 9999999999* 9999999999 will be converted to: 9.999999998E+19. The 1 at the very end of 99999999998000000001 would be the 20th digit of significance.

It is an unbound text box.