Decimal values got changed to zeros. Help!

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
hi Ken,
Ken said:
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".
Click to expand...
It is a currency value, so don't change it to decimal. Just change the
format of the controls.


mfG
--> stefan <--
 
Back
Top