numbers required to be input 0.xxx are defaulting to whole digits.

F

fishy

I have to input numbers as either 1 or 0.xxx into a form and no matter what I
select as the properties, this is changing after update.

Can anyone assist?
 
G

George Hepworth

You must enter these values as either "1", with no significant digits after
the decimal, or as decimal values with three significant digits? In other
words, valid values are between 0 and 1, correct?


George
 
F

fredg

I have to input numbers as either 1 or 0.xxx into a form and no matter what I
select as the properties, this is changing after update.

Can anyone assist?
Click to expand...

Changeing to what?

i suspect that the Field's datatype is Number... Field Size Integer or
Long Integer.
By definition, an Integer is a whole number, therefor it cannot be a
decimal value.

Change the field's datatype to Single, Double, or Currency (which can
have up to 4 decimals).
 
J

Jamie Collins

By definition, an Integer is a whole number, therefor it cannot be a decimal value.

Change the field's datatype to Single, Double, or Currency (which can
have up to 4 decimals).
Click to expand...

Or the aptly named DECMIAL type (which can have a decimal scale of up
to 27, assuming the OP's values are between 0 and 1 inclusive).

Jamie.

--
 
Top