Validation Rule

[KabirPatel]

Hi,

I have a text box in a form and would like to ensure that the contents of this text box does not exceed 27 characters in length (it can be less then 27 characters or even blank). How do I do this using a validation rule?

I tried LIKE "????????????????????????????" but this only checks for precisely 27 characters.

I do not want to use an Input mask as they are horrible.

Cheers,
Kabir

 

[pbaldy]

Personally I'd probably test elsewhere, but try:

Len([TextBoxName])=27

 

[KeithG]

try

Len([TextBox])<=27

 

[pbaldy]

Oops; misread it. Thanks Keith.