initial capitalization

  • Thread starter Thread starter Ruchi
  • Start date Start date
R

Ruchi

Please help with how to convert a name in its INITIAL
CAPITALIZATION format in a report.
 
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.
 
You must log in or register to reply here.

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

Coding in Text box on a report 3
Coding in a Report 1
Access 2.0 Format Question 2
Initial capitalization 4
Sequential Capital Leter 2
label differs by PC 2
Capitalize the first letter in each word 6
question 1

Back
Top