Forms 4.5 Handling columns number (3.1)

From: Darren Palmer <D.R.Palmer_at_btinternet.com>
Date: 1998/03/27
Message-ID: <6fhbuk$gt6$4_at_mendelevium.btinternet.com>#1/1


[Quoted] Dear all,

[Quoted] 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 Fri Mar 27 1998 - 00:00:00 CET

Original text of this message