Field filter

[Guest]

I have a form iin which one of the fields is for the users to enter a serial
number. Unfortunately, in many cases, the serial numbers supplied to the
users are preceeded by the letter S, however I advised the user NOT to enter
the letter S. Of course, users being who they are, don't always follow
instructions.

Is there any way to setup the format section of the field properties to
disallow the letter S as the 1st character of this field?

Specs:
Field is TEXT
Length 25
I did it through a macro but it's not always reliable.

 

[Guest]

Use the Before Update event of the control where they put the serial number in:

If Left(Me.txtSerialNumber, 1) = "S" Then
Cancel = True
MsgBox "Didn't I tell you not to use the S", vbQuestion+vbOkayOnly,
"Moron Detected"
End If

Of course, you may want to use a different message