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.
Hello,
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 in upper left area of answer which satisfied the question.
Thank You.