ISALPHA, ISNUMERIC functions?

  • Thread starter Thread starter CaptainWillard
  • Start date Start date
C

CaptainWillard

I'm trying to find the Access versions of the functions to determine
if a character in a string is A-Z or 0-9. I can't seem to locate the
functions in the help file. In a perfect world., Access would have a
function like ISTEMPLATE, which would work as follows:
ISTEMPLATE("A999A99", strField1) which would return T for
strField1="D102X34" and F for strField1=""D1023X4". Is there any
function like that, or any functions for matching strings by character
type? Thanks in advance for any help.
 
Please do not post duplicate threads.

If you want your post to appear in more than one group, enter all the group
names in the "Newsgroups:" field when submitting your post. This will post
a copy to each newsgroup. If anyone responds in one newsgroup, their
resolution will appear in all copies of your message. This prevents people
from spending time answering your question only to find that it was answered
by someone else in another newsgroup.
 
Back
Top