validation rules?

[lscheer]

I have a table with mailing address info and I need to restrict the users from typing a comma into the City field. I tried using a validation rule, and although I get no syntax error, it doesn't work. Does anyone have any suggestions?

Thx

 

[jimbrooking]

This is a cool trick I learned at :

In the text box's BeforeUpdate event put the following code:

If Me.tbxCity Like "*[!A-Za-z ]*" Then
MsgBox "Non-alpha character discovered in City name"
Cancel = -1
End If

The code as written will allow upper- and lower-case letters and spaces to accommodate city names like "New York". If you don't want to allow spaces, remove the space after the "z".

Jim

 

[lscheer]

Thanks, i'll try it...