Title Case

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
 
F

fredg

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.
 

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

format text to "title" case 3
The next Grand Theft Auto title has been officially announced 0
Change upper case to sentence case 4
Change background color in one text box based on text in 2nd text 4
First Character to Lowercase 2
blank fields on a name line 2
Correct Title Case 3
Formatting fields to Title Case 1

Top