Troubles with Validation Rules

Troubles with Validation Rules

am 11.01.2008 01:28:42 von Darrin

I'mtrying to apply a validation rule to a form field where all
characters and numbers are allowed, along with these: . ( ) * '
-

However, despite extensive Googling and reading, I'm unable to locate
the proper syntax to allow them all and restrict anything else.
Anyone point me in the right direction?!?

Re: Troubles with Validation Rules

am 11.01.2008 01:35:53 von Bob Quintal

darrin@stride-r-web.com wrote in
news:79fc6775-d250-4e99-b829-
50deb6599f7a@x69g2000hsx.googlegroups.co
m:

> I'mtrying to apply a validation rule to a form field where all
> characters and numbers are allowed, along with these: . ( ) * '
> -
>
> However, despite extensive Googling and reading, I'm unable to
> locate the proper syntax to allow them all and restrict anything
> else. Anyone point me in the right direction?!?
>
Easiest way to do this would be to code the OnKeyPress Event of the
control which grabs the character typed, passes that to the instr()
Function and disallows the character if the result is 0 (not in the
searched string) That searched string would contain the characters
you allow.


--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com