MS Access - Field Name Change

[Colleen2]

I currently have a database with several tables, queries and reports that use the field "Invoice Period", that name has now changed to "Calendar Invoice Period", is there a way for me to update that change without going into each table, query and report?

[Micron]

Every form, query, report, expression in controls, will break, so no easy task. I would have to test to recall what happens in a query if the table field was aliased as it's something I haven't done for a long time. Maybe somebody else will see this sooner and chime in with that answer. If queries and recordsources use the field name and not the alias then you probably could get away with that.

Can't you just leave the field name alone and change the labels on forms and reports to reflect the new name?

[Colleen2]

That is an option to change the new name but the report includes the old field name too but it pulls a different parameters

[davegri]

Access can help. First make sure autocorrect is turned on:


Then in table design, change the name in the master table.
Access will do a pretty good job of changing the name in form, reports and some queries.
It won't change rowsource SQL strings for comboboxes or listboxes.
It won't change SQL strings in VBA code.
To quickly examine queries and SQL in forms, listboxes and comboboxes you will find this useful:

Query Editor, Form Explorer, Rowsource editor (accessforums.net)

[Micron]

the report includes the old field name too

So you added the field, not changed the old field name?
If you changed the table field name, you have some work cut out for yourself.

[Welshgasman]

I currently have a database with several tables, queries and reports that use the field "Invoice Period", that name has now changed to "Calendar Invoice Period", is there a way for me to update that change without going into each table, query and report?

What do you care what it is called?
I would just change the caption for it in the table design?

[June7]

You can acquire a 3rd party add-in that can facilitate this. I used Rick Fisher's tool years ago but doesn't seem to be available anymore and had a cost (only $50). V-Tools is a freebie. https://www.skrol29.com/us/vtools.php

If you want to change fields names, recommend you eliminate spaces.

[MikeKincaid]

Rick Fisher's tool can be found here: http://www.rickworld.com/download.html
I have used V9 with Office 2016/2019 and O365 versions and it works. Plus worked with Rick for around 20 years. Great guy!