Solved

Upper and Lower case Function

Posted on 2000-03-31
1
139 Views
Last Modified: 2010-05-02
Does anyone know if there is a Function that I can use to change only the firstname's, middlename's and lastname's letters in a name, example :

paul peter smith to Paul Peter Smith

Thanks
0
Comment
Question by:tomcruisew
1 Comment
 
LVL 32

Accepted Solution

by:
Erick37 earned 15 total points
Comment Utility
use:

sName = StrConv(sName, vbProperCase)
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

I’ve seen a number of people looking for examples of how to access web services from VB6.  I’ve been using a test harness I built in VB6 (using many resources I found online) that I use for small projects to work out how to communicate with web serv…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now