Table Validation, don't allow # symbol

[Dryheat]

I am working in Access 2002 and I'm trying to create a validation rule for a text field in one of my tables. I need to prevent users from entering the '#' symbol as part of the customer name. Here's what I've found:

Not Like "*" &Chr(33)

This one works and prevents users from entering the '!' symbol in this field

Not Like "*" &Chr(35)

This one does something unexpected. Instead of preventing users from entering the '#' symbol it is preventing them from entering any numeric characters.

Please let me know if you have a solution.

Dry

 

[Remou]

You can include the hash in braces:

Not Like "*" & "[#]

 

[Dryheat]

AWESOME, that did the trick. Thanks for the quick reply.

Dry