Need to stop rounding up numbers - help!

D

Dalleu

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.
 
N

Nikos Yannacopoulos

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
 
O

Ofer

You probably have the field type set to tong, set it to double that will
allow you have decimal places
 
Top