Need to stop rounding up numbers - help!

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

Guest

I have a few fields which are amounts, I have kept them as standard numbers
though as the currency fluctuates with each record. I have put the field as
a standard number with 2 decimal places, in the table and the form's textbox
so the data should look like 2,345.95
But it rounds up as soon as i leave the field so it looks like 2,346.00
How do i stop this? is there any way without writing code? is this just a
property somewhere i need to change.
 
Dalleu,

Keep in mind that format and data type are two different things! I
suspect the fields in the table are type Integer or Long Integer, which
is why they cannot store decimals. Change the type to Double.

HTH,
Nikos
 
You probably have the field type set to tong, set it to double that will
allow you have decimal places
 
You must log in or register to reply here.

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

Round up number 2
Stop Rounding in Forms 2
Form Combo incorrectly rounding 1
Rounding Numbers 2
Preventing rounding numbers to nearest dollar 2
Round Up a Decimal 6
Excel Excel 2007 won't stop rounding down my formula results! 5
Rounding up! 2

Back
Top