I have most probably an easy question for somebody.
I would like to convert the first letter of each word in a text box to a capital and all others letter to lowercase after the text box loses focus no matter how the data is entered.
I am trying to do this in MsAccess, was that example for Excel, sorry for not being specific enough from the start.
I did try this in Access but it didn't work.
Yes that was for Excel. There are separate forums for Access and unqualified questions are generally assumed to be for Excel or Word here. You may find better answers in one of the Access forums, for example see forum702.
Meanwhile, I think this is what you are looking for in Access:
Code:
Private Sub Text1_LostFocus()
Text1.Text = StrConv(Text1.Text, vbProperCase)
End Sub
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.