initial capitalization

R

Ruchi

Please help with how to convert a name in its INITIAL
CAPITALIZATION format in a report.
 
J

John Spencer (MVP)

In a report, set the control's source to
=StrConv([SomeField],vbProperCase)

Make sure that the control and its source don't have the same name.

That will turn INITIAL CAPITALIZATION into Initial Capitalization.
 

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

Disable Outlook AutoCorrect with GPO 0
Need a macro to create a separate document that lists all capitalized words 6
Word isn't capitalizing the first word of each sentence 2
Capitalizing Words In The Middle Of Sentences 0
Converts HTML and PDF to Word 1
Coding in Text box on a report 3
Excel - Wich Function should I use? 1
Initial Capitals - how to avoid them? 1

Top