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


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