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

Word isn't capitalizing the first word of each sentence 2
Mail Merge Directory Conditional Page Break 0
Keep First Letters, with exceptions 0
Improving Macro That Keeps First Letter 0
Delete all data after a symbol in a field 0
VBA - exporting serial letters to single documents 0
Adjusting the layout of over 1000 existing Word documents using a macro-driven batch run 0
Creating a Chart on form from selected data in query. 0

Top