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.
 
Top