Converting letter case

G

Guest

I work with Access 2000, I need to change the letter case of the data from
upper case to lower case or vice versa, how can this be done in Access?

Thanks
Sonic
 
F

fredg

I work with Access 2000, I need to change the letter case of the data from
upper case to lower case or vice versa, how can this be done in Access?

Thanks
Sonic
Click to expand...

Look up the Ucase(), LCase(), and StrConv() functions in VBA Help.
 

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

Change all upper case letters to lower case 2
Differences between lower case and upper case 4
Change from all UPPER case letters 5
Force Lower Case 3
Case being changed in table 1
Case sensitive joins 5
Upper Case 1
Coverting Upper Case to Lower Case 1

Top