No number rounding

  • Thread starter Thread starter Teo
  • Start date Start date
T

Teo

Hi! How can I get a number value in my DB not to round, but to display the
decimals?
For some reason every time I insert a number with decimals, Access rounds it
up.
I already set the field property to number and chose to have 2 decimal
numbers but that doesn't seem to help.
Thanks much in advance,
Teo
 
Teo,

Make sure that the FieldSize property for your number field is set to:
Double, Single, Currency or Decimal.
 
Teo said:
Hi! How can I get a number value in my DB not to round, but to display the
decimals?
For some reason every time I insert a number with decimals, Access rounds it
up.
I already set the field property to number and chose to have 2 decimal
numbers but that doesn't seem to help.
Thanks much in advance,
Teo
Click to expand...
 
Back
Top