Validation Rule / Input Mask

[CHTHOMAS]

Hello Everybody,<br>I want the 1st two characters in a field as digits, 3rd a blank space and from 4th ownwards any combination of letters or digits. Eg. (66 abcd)<br>How to do that?<br>Thanks<br>Charley

 

[kathryn]

Enter this in the input mask field in design view for your table:<br><br>&quot;00 CCCCCCCC&quot;<br><br>This will allow you to enter up to eight characters after the space. Add or delete &quot;C&quot;s as needed.&nbsp;&nbsp;See the help entry for InputMask Property for more detail.<br><br>Hope this helps.&nbsp;&nbsp;Let me know if you need more.<br><br>Kathryn

 

[jazzz]

or try this<br><br>00&AAAAAAA<br><br>0 = Digit 0 to 9 Required<br>& = Any character or space Required<br>A = Letter or Digit entry Required<br><br>Or<br><br>00Caaaaaaaa<br><br>Same as above except <br><br>C = optional<br>a = note lowercase optional<br>