how to prevent user from entering certain character like ';' textfield

M

Mark@home

Hi,

I have a form that shows a textfield named "input"

how to prevent user from entering certain character like ';' textfield

Users may enter text numbers and some signs just not ; and " ....how can i
do this using the validation rule

thanks,

Mark Donners

Office access 2002sp3
 
A

Allen Browne

If you want to use a Validation Rule, it would be:
(Is Null) OR Not ((Like "*;*") Or (Like "*""*"))

You could also use the KeyPress event to destroy the keystrokes for ; and ",
by setting KeyAscii to zero for these keystrokes.
 
Top