more than certain number of Characters _Beep

[stann]

Hello

I need to flag if a field contains more than 11 characters. The field is called "number" and

it needs to be 11 characters or less, if it is more I need to show a dialog box to indicate it is incorrect.

How does one do this?

Thanks

Stan

[jscooper]

In the field defintion's validation tab there's a validation for Maximum number of characters.

[DanBrill]

jscooper's method will stop a user from entering more than 11 characters. If you need to clean up data that's already been entered and may be incorrect then you can do it with a calc field:

Flag = case(length(EnteredData)>11,1,0)