Ask Your Question

base table integer field displaying as decimal in form

asked 2019-09-18 16:51:06 +0100

dougcb68 gravatar image

updated 2019-09-18 22:47:27 +0100

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.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-09-18 17:49:53 +0100

Ratslinger gravatar image


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.

edit flag offensive delete link more



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.

Ratslinger gravatar imageRatslinger ( 2019-09-18 22:41:21 +0100 )edit

Thank You.

Ratslinger gravatar imageRatslinger ( 2019-09-18 22:48:39 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-09-18 16:51:06 +0100

Seen: 118 times

Last updated: Sep 18 '19