Setting field criterias (numbers and letters)

[gomes.]

The data that is to be entered in the field "Rank", is either RK1, RK2 or RK3

How would I make the validation in a table make the user enter the format RK(Number), with only numbers from 1-3?

Thanks!

 

[Dennisk]

2 Steps are required

1) create an input mask that only allows 2 Alpha and one numeric.

2) in the before update for the text box check then last character is 1,2, or 3

 

[neileg]

Or set the validation to be In (RK1, RK2, RK3)

 

[Dennisk]

even easier if RK is always a constant then you may not need to even store it, then all you need to do is check the number is between 1 and 3.

 

[gomes.]

Thank you all.