Title or Proper Casing Text in Access

G

Guest

In Excel there is the "Proper(text)" function that will transform all
uppercase or lowercase text into Proper or Title case

ex. JIM = Jim; 123 CHERRY STREET = 123 Cherry Street

Is there a way to do this in Access? I frequently get lists that are in all
uppercase and it is a pain in the butt to export and them to Excel.. fix
them... and then import then back in.

I get the feeling that I am doing this the very long way around. Any
suggestions would be great.
 
J

John Spencer

Since you asked this in the Queries group, you might want to know that
vbProperCase is equal to 3. The query won't recognize vbProperCase if you
are trying to do this directly in the query. You would have to use:

StrConv([Your Field], 3)
 

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

Convert to Proper or Title Case in Access 2003 2
Access version of =Proper 1
Title Or Proper Case 5
In Vista, How do I change all UPPERCASE text to Sentence Case? 1
Truncating Text Fileds 1
Proper(text) function on entire worksheet? 5
mailing address multiple lines 1
Excel has a proper function. How can I use this within Access 1

Top