R Ruchi Oct 19, 2003 #1 Please help with how to convert a name in its INITIAL CAPITALIZATION format in a report.
J John Spencer (MVP) Oct 19, 2003 #2 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.
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.