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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Title format

Status
Not open for further replies.
OOzy

OOzy

Programmer
Jul 24, 2000
135
SA
Dears,

I have a text field (255) named title. All titles are in CAPS. How can I change thier case to a Title case i.e. first letter only in CAPS
 
Sort by date Sort by votes
The way I've ahieved this is on the After Update Event of the Title field on my form I've got the following code:

Private Sub Title_AfterUpdate()
Title = StrConv(Title, vbProperCase)
End Sub

That should do it.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

ptrifile
  • Locked
  • Question
Format of Date from Query 1
Replies
2
Views
250
ptrifile
ptrifile
supportsvc
  • Locked
  • Question
Text to Format as Date? 1
Replies
5
Views
302
supportsvc
supportsvc
JustJosh478
  • Locked
  • Question
Alter Table to Change or Clear column format
Replies
1
Views
220
dhookom
dhookom
egstatus
  • Locked
  • Question
Displaying query results in a tabular format
Replies
1
Views
150
dhookom
dhookom
air1access
  • Locked
  • Question
Format text date to 1st day of month...
Replies
2
Views
264
MajP
MajP

Part and Inventory Search

Sponsor

Back
Top