Have Access easily select data for overtyping

Your Access forms will be easier to use if users can simply type over existing data without having to select it first. By adding a short procedure to each text box control's OnClick event to select the data automatically, users will not have to take time to click and drag over the existing data.

For example, to change the OnClick event for the First Name text box control in your Customer Data form, follow these steps:

  1. Open the form in design view.
  2. Right-click the First Name text box control and then select Properties.
  3. In the Event tab, click the Build button in the OnClick property box.
  4. Click Code and then OK.
  5. Enter the following code at the prompt:

    SendKeys "{Home}"

    SendKeys "+{End}"
  6. Press [Alt]Q.

Now, to update data in the First Name field, simply click inside the text box. Access highlights the entire entry so you can easily type over the existing text.

Miss an Access tip?

Check out the Microsoft Access archive, and catch up on other Access tips.

Help users increase productivity by automatically signing up for TechRepublic's free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.