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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

fishy - 12 Sep 2007 18:18 GMT

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?

Reply to this Message

George Hepworth - 12 Sep 2007 18:38 GMT

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

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

Reply to this Message

fredg - 12 Sep 2007 18:51 GMT

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

Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Reply to this Message

Jamie Collins - 13 Sep 2007 13:21 GMT

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

--

Reply to this Message

Joseph Meehan - 12 Sep 2007 19:04 GMT

Are you using an "integer" number type?

Signature

Joseph Meehan

Dia 's Muire duit

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

Reply to this Message