I would not allow it, still display a message box when the user tries to enter it. Alternatively, you could display the message box only if the user types the single quote twice or more in the same field. Ie: don't display it first time (maybe the user just mistyped), but display it if the user insists.

Vlad