stop rounding of figures in a sub-form

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!!!
 
A

Allen Browne

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

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

Top