cant input decimal numbers in fields

[Rui Sardinha]

Have a db that uses tare values. those tare values will be input by the user.
the problem is cannot give values to the fields with comas or point
example: "0.05" or "0.012
the field wont keep the valu
do u have any ideia where i went wrong????

 

[Allen Browne]

1. Open your table in design view.

2. Select the problem Number field.

3. In the lower pane, change the Field Size property from
Long Integer
to
Double

The integer types cannot store fractional values.

 

[Rui Srdinha]

Sorry.. i did what u sad, but...
everytime that i leave the field, the value after the point just disappear
example: "333.69" when i leave the field "334"

thank u

----- Rui Sardinha wrote: -----

Have a db that uses tare values. those tare values will be input by the user..
the problem is cannot give values to the fields with comas or points
example: "0.05" or "0.012"
the field wont keep the value
do u have any ideia where i went wrong????

 

[DubboPete]

change the format of the field to 'standard'

DubboPete