Capitalizing first letter of data in a query

  • Thread starter Sarah at DaVita
  • Start date
S

Sarah at DaVita

I have a query that creates a table. Some of the data contains all caps. I
would like to have the first letter of each word capitalized - CENTRAL
DIALYSIS CENTER would become Central Dialysis Center. I can do this in SQL
using the initcap function. I tried this in the SQL view of the query but it
was not recognized. Can someone help me with this?
 
D

Douglas J. Steele

Use the StrConv function. Since you're running in a query, you must provide
the value for the conversion factor (3) as opposed to using the named
constant (vbProperCase)
 

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

Capitalizing a Date 12
Coverting all caps in a field to proper 3
First Letter of Every Word Capitalized 4
Capitalizing the first letter in a sentence. 3
if first letter is not a \ 2
in access entering data with capitalized first letters only 1
Transforming many cells of all caps into first letter capitals onl 5
Solve query? 14

Top