Base table integer field displaying as decimal in form

I have a Base table with a field that is defined as integer type, but which displays as decimal (two places) in the table control of my form. I am at a loss.


If a control (column in table control in your case) is set as a numeric field, it defaults to two decimal places. This is just display and does not reflect the actual data type.

To change, edit your form. Right mouse click the table column in question. Select Column.... Then on the General tab of the properties dialog, change the value of Decimal accuracy to 0. Close & save.


Please do not re-title when question has been answered. It actually changes the link to the question and thus may nullify a link from somewhere else.

Instead click on the :heavy_check_mark: in upper left area of answer which satisfied the question.

Thank You.