Re: <at> TextToNumber Syntax

If VehQty is a field to the left of and/or above the paragraph in question
(or the fields are refreshed) and VehQty contains a text value less than 2
then  <at> TextToNumber(VehQty) < 2 will return True.  As a result the paragraph
associated with this hide-when formula will be hidden.

You could do some field validation to trap values entered into the VehQty
field that cannot be converted to a number.

 <at> If( <at> IsError( <at> TextToNumber(VehQty) ;  <at> Failure("You must enter a number into
this field.") ;  <at> Success))

 or just change the VehQty field to numeric.  Then you don't need to use
 <at> TextToNumber and Notes will do the validation automatically.

Regards,
Bob

Robert A. LaRock
Process Engineer
Standard Abrasives
Hesperia Division

lnotes-l <at> ozzie.notesnic.net wrote on 07/30/2004 15:21:33:

> =20
> I am using this to convert the text number entered into a text field and
> then doing a calculation on a form.
>
>
> This is in the "Hide paragraph if formula is true" tab
>  <at> TextToNumber(VehQty)< 2
>
> VehQty is and editable text field where they enter the number
>
>
> I am not getting an error in the formula window. Is this the correct
> syntax?
>
> TIA
>
> Jose