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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ISALPHA or ISNUMERIC functions ? 3
SQL strings with quotation marks or apostrophes trouble! 2
need help with form programming - print command button 2
add recordset to end of table 1
SQL Statement 2
OrderBy with multiple fields 1
Need help utilizing the "Like" function 7
Verify Canadian Postal Code ~ make the code work 2

Back
Top