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 Rhinorhino 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
Joined
Oct 31, 1999
Messages
2
Location
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