Formatting fields to Title Case

[Guest]

The address table I use is from a linked source where all information
defaults to uppercase format. I know how to format for just upper or lower
case, but is there a way to format a field to Title Case?

Thanks for your help.

 

[Marshall Barton]

The address table I use is from a linked source where all information
defaults to uppercase format. I know how to format for just upper or lower
case, but is there a way to format a field to Title Case?

Not really a format, but you can use a control source
expression like:

=StrConv(fieldname, 3)