Avatar of SteveCond

asked on 

Detect and convert uppercase (but not number) in a string

I need to test a string in Access vba to see if it contains any uppercase characters, warn the user, and then convert those characters into lowercase before saving. However, the string might contain numerical characters as well. Tests I've tried using LCase and strComp appear to treat numbers as uppercase and warn the user, although I'm happy to have the numbers accepted as they are. Any help appreciated (and also any tips on how I can test a string to see if its first character is a number and disallow it).
Microsoft Access

Avatar of undefined
Last Comment

8/22/2022 - Mon