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

[Guest]

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?

 

[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

 

[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?

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).

 

[Joseph Meehan]

Are you using an "integer" number type?

 

[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).

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.

--