Convert to sentence case

[deego55]

Hi-

Can someone let me know how to convert a fields text from word case to sentence case? For instance I need "Feedback Control of Dynamic Systems" changed to "Feedback control of dynamic systems." Any help is greatly appreciated!

Dave

[MarkWilson]

Left( Upper( TextField ) , 1 ) & Middle( Lower( TextField ) , 2 , Length( TextField ) -1 )

[-Queue-]

or Left( Upper(TextField); 1 ) & Lower(Right( TextField; Length(TextField) - 1 ))

[deego55]

Beautiful! Thank you a ton Mark!

[transpower]

But why would you want to do that? Title case is correct for proper nouns.