Set exactly 4 character in field named Surname

[amitrami]

Hello Good Morning to all,

I want to set exactly 4 character in field named surname in (Validation Rule or Text )ms access/so plz tell me how can i do it?

Also tell me Validation Rule vs Validation Text

[pod]

Check out http://allenbrowne.com/ValidationRule.html

[zmbd]

You don't need a validation rule per say
Go into your table design, select the field of interest.
In the properties grid at the bottom, general tab, set the field size to 4.
Any attempt to enter more than 4 characters will result in an error message to that effect.