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!

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

change to propercase

Status
Not open for further replies.
varean

varean

Technical User
Apr 9, 2001
17
US
I have a "name" field in an access 97' table with all records in uppercase, I need to convert them to propercase (first letter in cap's, rest in lowercase).
Does any one have any ideas on how to accomplish this.

Thanks a bunch!
 
Sort by date Sort by votes
Try using vbProperCase. I think you will find it most useful.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

sal21
  • Locked
  • Question
Check of valute change in text file 3
Replies
15
Views
322
strongm
strongm
2009luca
  • Locked
difficult to crteate a query very complicated 1
Replies
9
Views
875
Andrzejek
Andrzejek
2009luca
  • Locked
  • Question
USE find instead to loop
Replies
2
Views
205
Andrzejek
Andrzejek
marty1944
  • Locked
  • Question
error code 380 when trying to run the visual basic v6 deployment wizard
Replies
1
Views
357
marty1944
marty1944
sal21
  • Locked
  • Question
how to read the coordinates in from this file
Replies
3
Views
213
Ken01
Ken01

Part and Inventory Search

Sponsor

Back
Top