Select Text On Click
By Richard Rost 30 days ago
Select All Text in a Text Box On Click in MS Access
In this Microsoft Access tutorial, I'm going to teach you how to select all of the text in a text box on a form when you click on it. This way, you can just click and type, much like how Excel works when you click on a cell.
Gabriel from Plano, Texas (a Platinum Member) asks: When I click on a cell in Microsoft Excel, the entire cell is selected, and if I want to overwrite that, I just begin typing. In Microsoft Access, when I click on a field, the cursor goes wherever I click, which could be in the middle of the data or at the end or wherever. Is there a way that I can make it so that when I click on a field on a form, all of the data in that field is selected so I can just type over it instead of having to manually select it with the mouse? It works fine if I tab to it, but I use the mouse more than I tab around the form. I just want to click and type.
There is no extended cut, but here is the database download, and a link to the Code Vault:
Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the database template from class plus get access to the Code Vault. If you signed up on YouTube you have to register on my YouTube Find User page so I can set up your account here on my web site. If you're not a member, Join Today!
TechHelp Access 2016, Access 2019, Access 2021, Access 365, Microsoft Access, MS Access, MS Access Tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, select all text, SelStart, SelLength, Screen.ActiveControl, Len, Text Property, Excel Cell Click, Access form text select, Select all text Access form, VBA text selection, Access OnClick text select
Subscribe to Select Text On Click
Get notifications when this page is updated
|Keywords: TechHelp Access 2016, Access 2019, Access 2021, Access 365, Microsoft Access, MS Access, MS Access Tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, select all text, SelStart, SelLength, Screen.ActiveC PermaLink How to Select All Text in a Text Box When You Click on it in Microsoft Access|