Field Validation Rule to Exclude Ampersand

[Ken Hudson]

I am trying to create a validation rule for a table field that will prevent
the use of the ampersand character (&).
InStr(1,[strClientName],"&",1)<>0
does not work.
What is the correct syntax?

 

[Ken Snell]

Try

Not Like "*&*"

 

[Ken Hudson]

I found my problem.
InStr(1,[strClientName],"&",1)=0
is the correct syntax.

 

[Ken Hudson]

Thanks Ken.
That works also.

--
Ken Hudson

Try

Not Like "*&*"

--

Ken Snell
http://www.accessmvp.com/KDSnell/

I am trying to create a validation rule for a table field that will prevent
the use of the ampersand character (&).
InStr(1,[strClientName],"&",1)<>0
does not work.
What is the correct syntax?

.