Issues updating an existing form.

[gbailey7805]

The issue I am experiencing has to do with a form in the frontend database that I've created through a table in the backend database. I would like to alter the output display for a field so it only displays whole numbers but when I go to update the field properties in the backend database table it doesn't update in the frontend even after I have updated the table in the linked table manager. Any thoughts?

[NTC]

there is a difference between display and what is stored. if you just seek to manage the display - then in the form, in the property of the text box, change the Format to Fixed and change decimals = 0

if you want to only store whole numbers - then to preserve your current data you must run an update query to round them to integers; as well as change the field properties....

[gbailey7805]

Thank you for the reply. Those parameters are already set in both the front end and back end tables however in my form view the value still displays with several digits.

[NTC]

not sure what is meant by 'front end tables' - - - but my point is that the display is also controlled by properties in the form, as well as the table....so be sure to check the text box properties in the form. What you need is totally do-able though perhaps not intuitive - so experiment....