Lotus Notes FAQ Visit Our Sponsor!


Is there a workaround for the bug in @IsNumber?

@IsNumber has a bug where it can't discern between "123" and "123a". To get around this, use a combination of @TextToNumber & @Text.

1. FIELD testNum must be a number field.

2. For the Input Translation formula, use 

@TextToNumber(@Text(testNum));

3. For the Validation Formula, use 
@If(@IsError(testNum);@Failure("Field testNum not a number!");@Success);


Applies to Notes Versions: 3
Last Modified: April 18, 1996
Home *Notes R3 *Notes R4 *Notes/Domino 4.5 *Notes/Domino 4.6 *Notes/Domino R5