Can't get ANY formula to work

[hellothere4]

Hello, I've been trying to get the most basic expression to work: Len([field]) <3

However, I cannot get ANY expression to work, its like as if i were in excel and i typed in "=A1" and it just stayed as "=A1". I really can't figure out what I'm doing wrong, can anyone PLZ help!

 

[jeffreybrown]

Try putting the <3 in the Criteria field

Field: Expr1: Len([field])
Criteria: <3

 

[xenou]

Also check your references in the Visual Basic environment:

1) Alt + F11
2) Tools | References

Be sure Visual Basic for Applications is checked and nothing else is listed as "Missing"