cant input decimal numbers in fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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????
 
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.
 
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????
 
Back
Top