Multiple input mask for one text field

[L1sta]

Hi
I'm having trouble with some Validation for one of my users. They want a text field to either contain 5 digits (e.g. 41237) OR an 'S' followed by 4 digits 0-9 (e.g. S4123)
One or the other would be easy enough but I can't find out how to make it only accept one or the other.
Thank you for any help,
Lista

 

[randy700]

Maybe something like...

If (Left(txtField, 1) = "S" and IsNumeric(Right(txtField, 4))) or IsNumeric(txtField) Then ...

Randy

 

[PHV]

In the BeforeUpdate event procedure of the control:
If Len(Me![yourTextBox]) <> 5 _
Or (Not IsNumeric(Me![yourTextBox]) _
And (Left(Me![yourTextBox], 1) <> "S" Or Not IsNumeric(Mid(Me![yourTextBox], 2)))) Then
Cancel = True
End If

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[L1sta]

Thank You! works perfectly!