validation rule for 8 letters and numbers only

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to set up a validation rule, and bring up my own personalised
error messages, i need validation rule for a Car reg, e.g 8 characters max
letters or numbers, and one for Manufacturer of car, and another for phone
number
 
Rather than using field level or table level validation, I would suggest
using the Before Update event of the form:

If Len(Me.CarReg) > 8 Then
MsbBox "Maximum Length for Car Reg is 8"
Cancel = True
End If

And what ever is appropriate for you other fields.
 
Back
Top