I have a few fields in a database in which ALL of the characters/letters are in upper case. Years ago someone here told me how I can change the letters (except the 1st letters) to lower case. Can anyone give me some guidance?
Thanks!
I have a few fields in a database in which ALL of the characters/letters are in upper case. Years ago someone here told me how I can change the letters (except the 1st letters) to lower case. Can anyone give me some guidance?
Thanks!
Try StrConv() function.
Review http://support.microsoft.com/kb/815282
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
June,
I tried running this expression in a query & I got an Invalid syntax
City: StrConv([city],3)
Interesting, I tested this function in a query and it worked. I used the same syntax you show. I am testing in Access 2007.
Since I can't replicate the issue, would have to examine your db. If you want to provide, follow instructions at bottom of my post.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Here's the dbs (I think)
I don't get an invalid syntax error, I get circular reference error. Change the alias name to something else, not the name of the source field. The query works.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.