Help Please!!

[OOP]

I have a form linked to an access database. One of the
form fields needs to be validated before posting the
value into the table; the value entered must meet certain
criteria for example: six caracters, first three leters
followed by three digits. How can I solve this?
Please help,
Thanks in advance!

 

[Don]

OOP,

In the text box right click> Form Field Properties>(new window)
At the bottom of the window click on "Validate" Button (new window)
Set up the criteria you want..

HTH
--
The Don

IEEE Electronic Design Engineer
Interfacing Computers to Robotics
_______________________________________

 

[clintonG]

This is client-side validation and requires JavaScript when
the site is accessible via the Internet or alternatively client-side
VBScript if an Intranet.

That said, RegularExpressions are generally used for this
type of validation but there are other ways to use intrinsic
functions that can do the same thing.

Research the JavaScript FAQ
SEE: http://developer.irt.org/

--
<%= Clinton Gallagher
A/E/C Consulting, Web Design, e-Commerce Software Development
Wauwatosa, Milwaukee County, Wisconsin USA
NET (e-mail address removed)
URL http://www.metromilwaukee.com/clintongallagher/

 

[Poo]

There I can set if the input is going to be letters and
digits but no the sequence in which they have to appear...
:-((
Any other suggestion?

Thanks Don!