![]() Interestingly, even the Word help does not tell you. Note: The text changes only once the user has finished entering data and clicked away from the field. I cannot find the place in Word 2010 where I can customize the autocorrect options and switch off the automatic capitalization option in tables. Save your changes and test your form / report (Replacing the text in red “YourFieldName “ with the name of your field).Ĩ. YourFieldName = StrConv(YourFieldName, vbProperCase) On a new line directly between the two lines above add the following: (The text “ YourFieldName” straight after the words “Private Sub” will have automatically been replaced by the name of the field you are using)ħ. Click on the three dots next to the little black down arrow / triangle – this will open up the VBA window and you should see the following: On the “After Update” property click on the little black down arrow / triangleĦ. In the tools section of the “Design” tab click on the item called “Property Sheet”Ĥ. The following tutorial shows you how you can use VBA to set a field in your form so that regardless of how a user enters text in a field on a Microsoft Access form it will be automatically formatted with the first letter of each word in title case.Ģ. (also known as change text to proper case) APPLIES TO: ACCESS 2007, 2010 (UNTESTED IN EARLIER VERSIONS)
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |