Access 2000 Validation Rule: > 5 Characters < 17

  • Thread starter Thread starter Alan T
  • Start date Start date
A

Alan T

Hi,
I want a Validation Rule that checks for more than 5
characters and less than 17 for a password table.

The beast I could come up with in a 30 min web search
was...

Like "??????" Or Like "???????" or Like "????????" Or
Like "?????????" or Like "??????????" Or
Like "???????????" or Like "????????????" Or
Like "?????????????" or Like "??????????????" Or
Like "???????????????" Or Like "????????????????"

ugly or what?

What is the neat way of doing this please?

Thanks

Alan T
 
Alan,

The following works for me ...

In your table's design, set the Field Size Property to 17; that will take
care of the maximum. Then, in the Validation Rule Property, insert the
following: Len([PWD])>=5 Change PWD to equal your field name

You can insert text in the Validation Text Property like: Password must
have between 5 and 17 characters

hth,
 
Thanks for your help Cheryl

Regs
Alan
-----Original Message-----
Alan,

The following works for me ...

In your table's design, set the Field Size Property to 17; that will take
care of the maximum. Then, in the Validation Rule Property, insert the
following: Len([PWD])>=5 Change PWD to equal your field name

You can insert text in the Validation Text Property like: Password must
have between 5 and 17 characters

hth,
--

Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX


Alan T said:
Hi,
I want a Validation Rule that checks for more than 5
characters and less than 17 for a password table.

The beast I could come up with in a 30 min web search
was...

Like "??????" Or Like "???????" or Like "????????" Or
Like "?????????" or Like "??????????" Or
Like "???????????" or Like "????????????" Or
Like "?????????????" or Like "??????????????" Or
Like "???????????????" Or Like "????????????????"

ugly or what?

What is the neat way of doing this please?

Thanks

Alan T
Click to expand...


.
Click to expand...
 
Back
Top