Decimals on forms

[DDIC]

I have a form that has two fields I use to do some calculations.
The problem I am having is that I can't put in a number with a decimal, (such as 2.250). The number keep rounding up or down to the next whole number. I want to keep it all in decimal format.
How can I do this. Any help would be greatly appreciated.

 

[smed]

If the two text boxes on your forms are bound to a field in a table, have a look at the field definition a check they are not set to integar.

Also open the form in Design Mode.
Display the properties for each field and set the "Format" property to "FIXED" and specify how many "Decimal Places" you require.

Smed

 

[DDIC]

Did What you suggested smed, and still having the problem.
I'll will look at it some more, any other suggestions. When I put the data type to text it works good, is this the right way to do this.

 

[red91]

Open the table that the two fields come from. In the design view click on one of the fields that needs to be fixed. Then, go to the bottom of the screen and change the FieldSize property to Double, format to what you want, and decimal to what you want. Do the same for the other field. Save the table and then click on form view to check to see if it worked. Finaly open the form click on the box with the field in it and then properties to set the format and the decimal place. Since the table is where all the info is stored you can change the format of the form all you want, but it still won't save in the table unless you have the right format.

 

[DDIC]

Thanks red91 looks like it will work.