Proper Case in Reports

[Randy Clayton]

I have a report that reads text from a table that is in
all caps. I need to show that field in proper case on the
report. What is the correct way to format that field to
proper case in the report design view?

 

[Fredg]

Randy,
Use an unbound control.
Set it's Control Source to:
=StrConv([FieldName],3)

Be aware that this sometimes gives incorrect capitalization on some names.
McDaniel becomes Mcdaniel, O'Connor becomes O'conner, van der Meer becomes
Van Der Meer, and IBM becomes Ibm.

You can write a user defined function that refers to a table to see if the
name is one of the exceptions to First letter capital, rest lower case.

Good luck,