Re: Is alpha Numeric

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Angel_G (nomailplease_at_sorry.com)
Date: 04/16/04 

Date: Fri, 16 Apr 2004 12:50:24 -0700

Thank you.

"Graham Mandeno" <Graham.Mandeno@nomail.please> wrote in message
news:eWUY9q0IEHA.3572@TK2MSFTNGP10.phx.gbl...
> Hi Angel
>
> If Me!UserPassword Like "*[A-Z]* And Me!Userpassword Like "*#*" Then
> ' password contains both numbers and letters
> Else
> ' invalid
> End If
>
> If you want to also check that the password contains *only* alphanumeric
> characters, then add a third test:
> ... And Not (Me!UserPassword Like "*[!A-Z0-9]*")
> --
> Good Luck!
>
> Graham Mandeno [Access MVP]
> Auckland, New Zealand
>
>
> "Angel_G" <nomailplease@sorry.com> wrote in message
> news:%239zSZUzIEHA.2544@TK2MSFTNGP10.phx.gbl...
> > How can I tell if a field on a form (UserPassword) contains an Alpha
> Numeric
> > value. I want to make sure the field contains both, numbers and letters.
> > Can anyone help me with the right code?
> >
> >
>
>

Relevant Pages

  • Re: User Accounts
    ... Change the name of the account. ... hackers as a means of getting a foothold into your system. ... using all upper case or all lower case letters. ... It should contain at least eight characters. ...
    (microsoft.public.windowsxp.help_and_support)
  • Re: Naming convention for Login names?
    ... Normally, valid names should contain only letters and numbers, starting with ... "TestUser\ is not a valid name because it contains invalid characters". ... How would one know ahead of time whether the login contains invalid ...
    (microsoft.public.sqlserver.security)
  • Re: Problem setting up Encryption with Wireless Network
    ... When you turn on WEP - it will ask you to enter a passcode.. ... characters (could be mixture, could be all numbers, could be all letters - ... describes a point in their life and then turning that phrase into their ...
    (microsoft.public.windowsxp.basics)
  • Re: Frying and egg
    ... The OCR sorting equipment for letters still ... expects uppercase characters, I think. ... The Canadian system avoids several letters as well. ... not individual carrier routes (for which ...
    (alt.usage.english)
  • Re: Data Validation, Identify Duplicates and Limit imput
    ... The first 3 characters must be UPPERCASE letters A to Z. ... ABC 1234 ... error message if a duplicate reference is entered however I need to add ...
    (microsoft.public.excel.worksheet.functions)