Validation - No less than 4 characters 1

[Hargreavesk]

Hi,

I have been looking through the validation areas but have not come across anything that can help me. I have a name field on a form which should not be any less that 4 characters long. The field will include alpha and numeric characters as well as spaces. I don't want to limit the field to one type of character just make sure that the information is more than 4 characters long whatever it's type.

Can anyone help?

Regards

Kate

 

[DrSimon]

A simple thing could be to put a validation rule for the field in the table design like
Len([Field_Name])>3
and then a validation text of 'Must be >3 characters'.
This doesn't restrict any characters so would include punctuation, but it wasn't clear if that was a problem

 

[Hargreavesk]

Thankyou DrSimon. This works great!!!

Kate