I prefer using the shareware product Find and Replace product for this. It is
inexpensive product and is pretty thorough. It can fix the name in the table,
in all queries, in references on forms and reports, in macros, and in my VBA
code. Plus it allows me to make the decision on a case by case basis or
accept change all if I wish.

Find and Replace: http://www.rickworld.com
Has versions to support up to Access 2007 (Beta version only for 2007) -
Shareware (Approx $40-$60 depending on version)

I have no association with the product other than I use it and have paid for
two copies (one personal and one at the office)

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

John W. Vinson wrote:
On 31 Jan 2010 01:55:52 GMT, "David W. Fenton"
wrote:

Not meaning to dispute the recommendation that it should probably be
OFF in most cases, I'm finding it useful in a project I'm working on
right now, where all the table fields are prefixed with the prefixes
I only use for variable names. Every text field is named
txtSomething. This is highly annoying to me, as you it's impossible
to navigate a field list by typing the first letter of the field
you're looking for.

In any event, when I'm done doing the renaming and checking all the
dependencies, I'll turn Name AutoCorrect OFF. I think the problems
with it likely come from it being turned on for production use
(where it's just not needed).

Good point David - it's been a couple of years but I've done the same: turn it
on, make specific changes, and turn it back off. Thanks!