March 17th, 2010, 02:16 PM
posted to microsoft.public.access.tablesdbdesign
|
|
Field Validation Rule to Exclude Ampersand
Thanks Ken.
That works also.
--
Ken Hudson
"Ken Snell" wrote:
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
.
|