problem with decimal places (Rounding)

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

Guest

i have a table "invoice register" and a form . there is one field "Roe" . I
have set the property to currency , with input mask 0.00000000. but , when i
enter a value . it will round it .i.e. if i enter this 0.00043000 it will
round it to .00040000. what should i do to prevent this "
 
If you mean you set the field's field size to currency, that is the problem.
Currency hold 4 digits after the decimal point and no more. If you need then
you will need to use Double as the field type.
 
Back
Top