Does changed Field Name automatically propigate to queries and forms ??

T

tmb

When I change the field name in a table... does that new name propigate
to all related queries and forms ?

Or do I have to manually find each query and form and make the same
field name change?

thanks for any help.
 
R

RuralGuy

Sorry, it is a completely manual process. Renaming a field tends to
break your forms, queries and reports.

When I change the field name in a table... does that new name propigate
to all related queries and forms ?

Or do I have to manually find each query and form and make the same
field name change?

thanks for any help.

_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.
 
G

George Nicholson

If you have NameAutoCorrect turned on, queries and forms *should* be
updated. Modules, vba code will not be. (The Help file contains more info on
NameAutoCorrect limitations). If it isn't turned on, it is a manual process.

Having said that, NameAutoCorrect is known to cause other problems within a
db, so it's true value is, ahem, limited, at best. Depending on the size of
your project, you're probably much better off with a 3rd party tool to do
the renaming for you (SpeedFerret, etc.) or a really good documentor to make
a manual process a snap.

HTH,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top