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,
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Reports that sift records from different tables 0
Can't create a report from my query in Access 1
Converting GPS coordinates to decimal in Report 0
Access Access Report Works on One Machine but not Another 3
Paper size being lost when moving to a different computer 0
Filtering subreports on main report 0
records not sorting properly in report 1
Report using Select Case 5

Back
Top