Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Proper Names

Status
Not open for further replies.

umberto

Programmer
Oct 31, 1999
2
US
I want to be able to enter names (alpha) in any case, either all lower or all upper. How do i use vbProperCase to accomplish this?
 
vbPropercase converts only the first letter of an item to upper case<br>
vbUppercase converts to all upper case<br>
vbLowercase converts to all Lower case<br>
syntax<br>
Text1 = strconv(mydata,vbUppercase)<br>
PS <br>
to get help type in a word in hte design view say vbPropercase<br>
double click it to highlite the word<br>
then Press F1 for help on it<br>
it will work on almost anything.<br>
<br>

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top