Rule setting minimum characters for a field

[Wayne Cramer]

I have an Access table with a field called Purchase Oreder Item. The field must be all numbers and the length can be from 10 characters to fourteen characters. I have no problem requiring all numeric characters with a validation rule and setting a maximum length with the input mask. The problem is requiring the minimum of ten numeric characters. The operator must enter a minimum of ten characters and no more than fourteen. Please help.

 

[RuralGuy]

Data entry should be through a form and checking the Len() of the input in the BeforeUpdate event is easy.

 

[Simon_MT]

Use an Input Mask here's an example:

>99LLaaaaaa;;_

First 2 characters must be numeric, the next two must be alphabetic and the following 6 are optional.

Simon

 

[Wayne Cramer]

Rural Guy,
Your solution worked perfectly. Thanks!

 

[RuralGuy]

Glad I could help Wayne. Thanks for posting back with your success.