Validation Rule

[johnbird1988]

Hello

I would like to create a validation rule in the table design view that will only let you enter a vaule if it meets the specific format below.

I need it always to start with "HWE" and then contain 6 numbers only. for example:


HWE123456
HWE654321

How can I created this in the validation rule box. I have tryed
Like "IRC??????"

This works but i can add text after the IRC and i need this only to be a number.

Please Help

Many Thanks

John

 

[boblarson]

You can put this in the InputMask property:

"HWE"000000

and it will automatically add the HWE (they don't have to type it) and it won't let any other letters in and it will require 6 numbers.