Validation Rule
Field
|
Value
|
Description: |
Validates that the Account Number is 8 character. |
Formula: |
LEN(AccountNumber) <> 8
|
Error Message: |
Account Number must be 8 characters. |
Error Location: |
Account Number |
Explanation
What is expected?
Account number must be 8 characters.
What is not expected?
When account number is not 8 characters, give an error.
You should write your formula for not expected to get an error.
LEN(AccountNumber) <> 8