Ask Your Question

Why does the decimal place keep resetting to zero?

asked 2019-04-13 04:27:12 +0100

JustMe gravatar image

I have a base table with a number column, set to one decimal place. Every time I add a decimal, it resets. For example, 1.5 becomes 1.0 as soon as I click in another column or record. Am I doing something wrong?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-04-13 04:49:43 +0100

Ratslinger gravatar image


To be able to have decimal value in a field, the table property must specifically be set for Decimal places. There is also the Field Format to display the number of decimals. Now, if the Field Format is set for one decimal but the Field property is set to zero, then you get what you are seeing.

You need to change the field property in the table by editing the table and modifying that field.

edit flag offensive delete link more


That did it. Thank-you!

JustMe gravatar imageJustMe ( 2019-04-13 05:06:50 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-04-13 04:27:12 +0100

Seen: 51 times

Last updated: Apr 13