Validation Rule - Must enter number then letter

[smally]

Hello,

I was hoping someone could help me with a validation rule for a table.

What I require is for you only be able to enter specific data, for example the first character must be a number and be 7, 8 or 9, and the second character entered must be a letter, only letters available are A, B, C, D, E, N and S. For example these will be accepted 9C 8D 7B 7S 7D 8E, other will not (3S, 7G, B8)

Can anyone tell me what it is i enter into the validation rule box or direct me to any online help with this.

Thx

 

[trucktime]

Validation

You can probably accomplish this as follows:

In the field use an Input Mask: 0L

And use the On KeyDownEvent of the field to specify which characters are allowed.