Forum Discussion
How do you simply Capitalise first letters of words in a text box
https://docs.microsoft.com/en-us/office/vba/language/reference/user-interface-help/strconv-function
Do you could use the control's After Update event to apply StrConv to the controls value.
Daniel_Pineault I haven't got a clue want any of this means. I don't do code. What is a string or a StrConv() function?
As I said in my original post I am use to Lotus Approach, which did all that for you by just checking a box on what you wanted to do. It was so simples. You need a degree to use Access.
Thanks anyway.
If you need to use Access, you probably need to invest some time and effort into learning how to use the various tools it provides--including VBA. If not, then I understand Lotus Approach is still sold....
In this case, a string is simply that, a string, or series, of one or more characters. A string can contain both alpha characters and digits. For example, SN10101D is a string consisting of three alpha characters and 5 digits.
A person's first name is a string. A person's last name is a string. All of the sentences in this post are strings! All of the paragraphs are also strings in that they consist of multiple alphabetic characters one after another. The entire post is, in turn, a string.
What you need to do is apply the StrConv() function to the string your users type into the text box control on the form. Daniel explained how you can do that. Open the form in design view. Find that control. Use the form's property sheet to find the right event and use Daniel's suggestion.
You'll find some information about the StrConv() function here.
