stop rounding of figures in a sub-form

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

Guest

I have set up a sub-form in my access data-base. When for example money
figures are entered in, they are automatically rounded the the nearest
figure. The properties are set for 0 decimal places.

Does anyone know how I can stop this????

Please help asap!!!
 
There are 2 issues here:
a) what data is stored, and
b) what data is displayed.

Setting the Decimal Places property affects only how the data is displayed.
If it is a suitable data type, it will still store the fractional values.

Your subform is bound to a table. Open that table in design view, and select
the field where the data is stored. What is the Data type of this field? If
Number, change it to Currency. (If you have a reason to, you could change
the Field Size property to Double in the lower pane.)
 
Back
Top