Proper Case in Reports

  • Thread starter Thread starter Randy Clayton
  • Start date Start date
R

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?
 
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,
 
Back
Top