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?
Hello,
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.
That did it. Thank-you!