format currency to 5 decimals

[BobW2961]

Hello,
I have a currency field that is set to 5 decimals in the table.
When a value is entered into the field, it is rounded. Is there a way to top this?
for example.
If I enter 1.00007 the field changes the value to 1.00010
I would like the field to stay at 1.00007.



Thanks

[pbaldy]

The currency data type only goes to 4 digits. Try single or double instead, but be aware that they're floating point.

[BobW2961]

i'm not sure I understand the consequenses of changing to a floating point. I assume I would just have to add the "$"s myself in the reports.

[pbaldy]

I've seen instances where (to simplify) 2 + 2 does not equal 4. The computer might be storing 3.9999999999999 or something like that. I forgot about Decimal, so maybe try that first.

[CJ_London]

I assume I would just have to add the "$"s myself in the reports.

use the format property to do this

[davegri]

I suggest using Decimal and specify scale and precision properties in the table.
Precision is the total number of digits allowed in a number, including left and right of the decimal.
Scale is the number of digits allowed to the right of the decimal.


So 1234567.89 has a precision of 9.
123456.789 has a precision of 9 and a scale of 3.


A precision of 4 and scale of 2 would result in a number with a maximum value of 99.99


Percent designations like 125.5% would require precision 4 and scale of 3 (not one) since it is actually stored as 1.255.


Precision has a maximum value of 28, but textboxes in forms allow only a max of about 15 decimal places.