Re: Forms 4.5 Handling columns number (3.1)

Give a format mask for that item as 99.9 or give high values as 99.9. Or do both

This sure is easy. Isn't it.

Anu.

Darren Palmer wrote in message <6fhbuk$gt6$4_at_mendelevium.btinternet.com>...
>Dear all,
>
>I have a numeric field which is defined as number(3.1)
>
>When the user enters the following values there is no problem
>
>99.9
>
>How can I stop the user entering 999 on the form - the form allows
>it but the database does not because the value is larger than the
>precision for this column
>
>Thanks in advance
>Darren
>
>
Received on Sat Mar 28 1998 - 00:00:00 CET