calculation rounds numbers...make it stop

  • Thread starter Thread starter Rob Bergstrom
  • Start date Start date
R

Rob Bergstrom

I have code in a form to calculate a percentage.
The first textbox has the number and on an event the second textbox is
calculated (1% of 1st textbox)

The problem is they are both currency fields and the second one drops the
cents and leaves only .00 every time.

I can't find how to make the cents show up too.

the code is simply: Me![DPCalc] = Me![DownPayment] * 0.01


Help?
thanks,
Rob
 
do you have the result field DEFINED (not the format but the
definition) as in integer or as float or something that allows for
decimals. It cannot be integer.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Excel 2007 won't stop rounding down my formula results! 5
Currency and the number of decimal places 3
Rounding to Curreny not Working 4
why is my currency is rounding off. 2
Excel Stop Excel from displaying rounded values 4
Rounding problem 10
Rounding to the nearest cent...currency values 3
Rounding Numbers into Retail Amounts 4

Back
Top