Sentence Case

[Former Member]

Experts,

I am using CR2008 and need to Convert text from:

I AM IN CAPITAL CASE

to

I am in capital case

ProperCase() will not work since it gives:

I Am In Capital Case

Thanks

Sunil

[abhilash_kumar · Accepted solution]

Hi Sunil,

Try:

{String field}[1] & LowerCase(Mid({String field},2))

-Abhilash

[Former Member · Accepted solution]

Thanks, Abhilash.

Exactly what I was looking for. God bless you, my friend .

Sunil

[Former Member]

Or If you need I capital and remaining small then use this.

uppercase(left('I AM IN CAPITAL CASE',1))&lowercase('I AM IN CAPITAL CASE'[(InStr ('I AM IN CAPITAL CASE', " ") + 1) To Length ('I AM IN CAPITAL CASE')])

[former_member198639]

LowerCase(str)