Title or Proper Casing Text in Access

  • Thread starter In need of assistance
  • Start date
I

In need of assistance

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

Top