@Error (Formula Language)

Allows you to generate an error condition within an expression. This is useful if you want to evaluate the current values in several fields and need to know if an error has occurred in the entry of any of them.



Return value



Use @IsError to test for a data entry error.

When an error has occurred, @Error is returned. The function cannot return any other value.

@Error always results in an error condition when it tests a single value. If you use @Error alone as a formula, you will always generate an error.

You cannot test for an @Error value with any operator or @function other than @IsError. If you use an error value as an argument to an operator or @function, the return is always@Error.


Read the following examples closely to understand the difference between @Error and @IsError.
  1. This example returns the value in the Price field if it is greater than 100, otherwise it returns @Error.
  2. This example checks to see if there is an @Error in the field named Price. If there is an @Error, the string There is an error in the price field is returned. If the contents of the field are anything other than @Error, Price Field Okay is returned.
    @If(@IsError(Price);"There is an error in the price field";"Price Field Okay")