How do I format text to Title Case

[Guest]

My Access database is used by lot of people who can't be bothered to change
case when typing. I need to format the text for use in mail merge.

 

[Jeff Boyce]

Beryl

Depending on version, you can use StrConv() function.