Thread: Field Validation Rule to Exclude Ampersand
View Single Post
  #1  
Old March 17th, 2010, 02:46 AM posted to microsoft.public.access.tablesdbdesign
Ken Hudson
external usenet poster
  
Posts: 82
Default Field Validation Rule to Exclude Ampersand
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