Troubles with Validation Rules

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?!?
Darrin [ Fr, 11 Januar 2008 01:28 ] [ ID #1905380 ]

Re: Troubles with Validation Rules

darrin [at] stride-r-web.com wrote in
news:79fc6775-d250-4e99-b829-
50deb6599f7a [at] 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
Bob Quintal [ Fr, 11 Januar 2008 01:35 ] [ ID #1905384 ]
Datenbanken » comp.databases.ms-access » Troubles with Validation Rules

Vorheriges Thema: Access randomly changed paper size for default printer
Nächstes Thema: Restricting combobox to Filtered Form