Title Case

  • Thread starter Thread starter Kevin
  • Start date Start date
K

Kevin

Help... my mind is a blank and I can't find anything that
helps. How can I format a text field on a report to Title
Case (Sentence Case)?
Thanks!!
Kevin
 
Kevin said:
Help... my mind is a blank and I can't find anything that
helps. How can I format a text field on a report to Title
Case (Sentence Case)?
Thanks!!
Kevin
Click to expand...

Kevin,
If This Is What You Mean Then,
in the AfterUpdate event of the [SomeField] control:

[Somefield] = [StrConv([SomeField],3)

Note: this will improperly convert names that ought to have more than
one capital letter in them, such as McDonald to Mcdonald, etc., and IBM
to Ibm.
There is a coding work around.
Post back if that's important to you.
 
Back
Top