SLP How to set Uppercase of the first letter in each word in a field

Dear all,

In crystal report, how to set a field to be uppercase of the 1st letter of each word?
e.g.
original field value = "it is a CAT"
output = "It Is A CAT".

That's exactly PROPER in excel function.

Thx

 

You may use ProperCase in Crystal Report

e.g.
ProperCase ("LINDA FONG")
This example will return "Linda Fong".

 

Can it return "LINDA FONG" again if I use ProperCase?

 

This proper function is the same as in Excel. You cannot reverse the changes.