Let Access take care of name changes for you

Sometimes you have to change the name of an element in your Access database -- and, as it follows, every other instance of that name. Don't miss a single occurrence with this tip from Mary Ann Richardson.

When you need to change the name of a table, field, control, form, query, or any object in your Access database, you don't need to go through your database and change every instance of that name manually -- have Access do it for you.

For example, suppose your database contains a form with fields bound to a table, and you change the names of fields in that table. To have Access propagate those name changes to the form, follow these steps before you make those changes:

  1. Go to Tools | Options and click the General tab.
  2. Under the General tab, click in the NameAutoCorrect section, and click to select the Track Name AutoCorrect Info and the Perform Name AutoCorrect check boxes.
  3. Click OK.

To activate the NameAutoCorrect option in Access 2007, follow these steps:

  1. Click the Office button, and click the Access Options button.
  2. Select Current Database on the left column.
  3. Scroll to Name AutoCorrect Options and then click to select the Track Name AutoCorrect Info and the Perform Name AutoCorrect check boxes.
  4. Click OK.

Now when you open the form, Access looks for all objects that the form depends on to see if there are any discrepancies in the names of the relative objects, and makes the changes accordingly.

Note that Name AutoCorrect will not propagate changes made to objects in Access Projects, SQL code, references in VBA modules, names of fields in linked tables, replicated databases, or macros used for toolbar and menu objects.

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.