Text box to table

[Boomshank]

Hello,

I have a form that performs a calculation, i am trying to add the data in the text boxes into a table. I have managed to get the data into the table however one of the text boxes contains a percentage and once entered in the table rounds up to the nearest whole number, i have tried to set the field to 2 decimal places but it doesn't work.

Any Ideas?

 

[DCrake]

Why are you attempting to store a calculation in a table? These should be performed dynamically using queries. Unless there is a valid reason for storing the result then aviod it at all times. Remember Columns are expensive, rows are cheap.

 

[gemma-the-husky]

it will be either the formatting of the number in the table (it needs to be a double, not a long or integer), or in the textbox

check both again.