Thread: Field Validation Rule to Exclude Ampersand
View Single Post
  #2  
Old March 17th, 2010, 02:54 AM posted to microsoft.public.access.tablesdbdesign
Ken Snell
external usenet poster
  
Posts: 177
Default Field Validation Rule to Exclude Ampersand
Try

Not Like "*&*"

--

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


"Ken Hudson" wrote in message
...
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 Hudson