The following code converts a name to sentence case: LastName = StrConv(Trim(Nz(LastName)), vbProperCase)<br>It works well. But sometimes part of a name should be in lower case especially some of the northern European names like van Dyke.<br>Is it possible for the code to operate but to be able to edit the data after it has been entered?<br><br>Thanks in advance.
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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Case conversion edit
- Thread starter JMM
- Start date
If this code is part of a form, you could re-display it and give the data entry person a chance to alter it. Maybe run the code as validation for the field... <p>Terry M. Hoey<br><a href=mailto:th3856@txmail.sbc.com>th3856@txmail.sbc.com</a><br><a href= > </a><br>
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question