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.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s