Decimal places in Tables

[Teeboy]

I cant get access to display a number in decimal format every time i enter a number e.g. '23.45' access rounds it down or up depending on the number of course. the same happens when entered in a form. I have tried various options in the field properties but nothing works. It must be simple to do.

 

[Cbrine]

Have you tried

Fixed
2 decimals

On the table?

HTH
Cal

 

[Teeboy]

Yes! The number stays as decimal but still rounds. e.g. 23.98 defaults to 24.00. Weird!

 

[Cbrine]

Are you looking directly at the table, or a query or a form value? Each one of these levels could be changing the formating of the value? Talk about too much flexibility. Could be that it's rounded at a different level?

Cal

 

[Andrew Fergus]

You mentioned at the beginning that you were entering the numbers via a form. Following on from Cal's suggestion I recommend you look at the form design to see if the particular box into which you enter the number is changing the format. If you have a look at the properties of the box and report back anything unusual (e.g. an after update macro, a rounded "format" or an unsual control source value etc.). Also, if you look at the query that the form is based on, does the query include anything that looks like it is rounding the value?

HTH, Andrew.

 

[Teeboy]

I have stripped it back to the table and when entering numbers in they do not work 24.98 still goes in as 25.00

 

[Teeboy]

mmm......

not many replies?

Does this mean no one knows????????

 

[Andrew Fergus]

I take it that you have checked the table design and confirmed the problematic field is not an integer, it is a "double" field size and has "2" in the decimal places box?

Have you tried creating a new table with the same fields and testing that? If you can get the new table to retain the decimal places then you could copy the data across from your original table to your new table. To preserve your queries, forms and reports you could then rename the old table to [yourtablename_old] and rename the new table as the original table name. I realise this hasn't addressed the issue but it may resolve the problem.

If you can't get this to work, is there a global setting on the PC that is over-riding the decimal places?

HTH, Andrew.

 

[Teeboy]

Thank you everyone for you help tis now sorted