Minimum field lengths in a table 1

[Terrier]

How can I specify the minimum field length in a table?

I have a field which MUST be 13 characters long, anything more or less is unacceptable.

Advice appreciated.

 

[cheerio]

In table design view key into the validation rule box near the bottom of the screen

Len([myfield])=13

substituting the name of the field for myfield

If you want to exclude spaces nest a trim function within the Len function.

Access is not totally secure on this as a user form can be created that has the rule deleted but that requires a deliberate act.

Ken

 

[Terrier]

Ken thank you, that works a treat.

 

[cheerio]

glad to have helped