excess decimal places

[Guest]

I have a form showing currency. When I click on a text box, the usual 2
decimal places convert to FOURTEEN! Why is this? It is most annoying and
time consuming.
eg $1.24 becomes $1.24000000953674. Any help on this please

 

[Guest]

Hi Benedict,

You can use the Round function to truncate the value to two decimal places.
Here is a link to a KB article that I think you will find helpful:

ACC2000: Round or Truncate Currency Values to the Intended Number of Decimals
http://support.microsoft.com/?id=210564


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

:

I have a form showing currency. When I click on a text box, the usual 2
decimal places convert to FOURTEEN! Why is this? It is most annoying and
time consuming.
eg $1.24 becomes $1.24000000953674. Any help on this please

 

[John Vinson]

I have a form showing currency. When I click on a text box, the usual 2
decimal places convert to FOURTEEN! Why is this? It is most annoying and
time consuming.
eg $1.24 becomes $1.24000000953674. Any help on this please

You're storing the data in a Number... Double datatype, which is an
APPROXIMATION stored to 14 decimals.

Change the datatype from Number to Currency.

It's confusing because you can apply a currency Format to a Number
datatype field - but that doesn't change what's stored, only what's
displayed.

John W. Vinson[MVP]

 

[Guest]

Thank you, John. That proved incredibly easy to fix. I had currency showing
on the form, but number on the source table. It took 30 seconds to change,
and the excess decimals have magically disappeared! Cheers!

 

[Guest]

Thanks Tom. See other reply.