I have a SSN field. I want to display an error message upon submitting the page if the user has entered something like "111111111" or "222222222",etc...up to 9. Also I want to reject "123456789".
Would the correct way be to write
If txt_SSN.text = "111111111" Then
app.msgbox "error message"
ValidateCustomer = False
And how could I make this into a case statement for the others?
Thanks for any help