Re: Is alpha Numeric

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

From: Graham Mandeno (Graham.Mandeno_at_nomail.please)
Date: 04/16/04 

Date: Fri, 16 Apr 2004 12:35:38 +1200

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)