Formula Language

HI

@If(@IsError(BonusTX);

@Failure(“Please enter a number”);

@SetField(“BonusTX”;“”));

@Do(

@IsNumber(BonusTX); @Success; BonusTX!= “”; @Success; @Failure(“Please enter value”));

i want to check where the entered value is Number or not ? if the entered value is numer then there is no problem ? but if not then the present value should erased and cursor should point to that field /! the above code is not working is there any formula language for for erasing the value since @setfield is not working?!!!

Subject: Formula Language

hi,

make a number field…

in the input Translation of the field paste this code in:

@If(!@IsNumber(@ThisValue);@Do(

@Prompt([OK];“Wrong Value”;“Enter a number”);

@SetField(@ThisName;“”))

;@Success)

That works…

Bernhard