Thread: Field Validation Rule to Exclude Ampersand
View Single Post
  #3  
Old March 17th, 2010, 03:04 AM posted to microsoft.public.access.tablesdbdesign
Ken Hudson
external usenet poster
  
Posts: 82
Default Field Validation Rule to Exclude Ampersand
I found my problem.
InStr(1,[strClientName],"&",1)=0
is the correct syntax.

--
Ken Hudson


"Ken Hudson" wrote:

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