Decimal values got changed to zeros. Help!

[Guest]

Hello Dear Access Folks,

I painstakingly research values and entered them in dollars and cents,
designed as currency. But, then my boss said I should take off the dollar
sign. So, I went to design view and changed it to "number" and kept "two
decimal places". I went back to chart view and all the cents, the numbers
after the decimals, had all changed to zeros! Then, I tried changing it back
to "currency", but the zeros remain. What do I do?

Thanks very much,
Ken

 

[Douglas J. Steele]

The default data type when you choose Number is Long Integer, which doesn't
support decimals. When you changed to Number, you also needed to change the
Field Size from Long Integer to a data type that supports decimals (Single,
Double, Decimal).

Unfortunately, you've lost the decimal points now. If you need them, you
have no choice but to reenter them.

 

[Stefan Hoffmann]

hi Ken,

I painstakingly research values and entered them in dollars and cents,
designed as currency. But, then my boss said I should take off the dollar
sign. So, I went to design view and changed it to "number" and kept "two
decimal places".

It is a currency value, so don't change it to decimal. Just change the
format of the controls.


mfG
--> stefan <--

 

[Guest]

Thanks very much!