Can you rename a field and have it rename everywhere else it's referenced?

[Bayou BoB]

I made the mistake of using "Date" as one of the field names in a
table I use to track attendance. Can I rename that field in the table,
and then have it automatically changed everywhere else that field is
referenced, in the forms, querys and reports? How do I do this simply
using Access 2002?

Many Thanks,

Kevin

 

[Cheryl Fischer]

Kevin,

There is really no easy way to do this. You can use the Find/Replace (or if
you're very confident, the Replace All) option in VBA. However, where the
fieldname is used in properties in controls on forms and reports or in
queries, things become tricky. You may want to look into some third-party
help:

Find and Replace:
http://www.rickworld.com/

Speed Ferret:
http://www.moshannon.com/

hth,