Updating control names in VBA

[ijo68]

Hello Everyone , as always I want to thank everyone for contributing to this forum.

I just found out that I used some reserved words in my tables and want to correct this.
What would be the easiest way to update the VBA code for all the reference to the corrected fields and controls.

Thank you in advance

[ranman256]

if you've already named the fields and programmed around them, its best to leave them As-Is. You'll just get errors by renaming them.
even tho access says its reservered, its just a warning. You can have fields called: Name, Date, Note.

Its best to avoid these names if youre starting from scratch.
But if you DO rename them, be prepared to fix all the errors that goes with it.
You can globally replace vba module references, but may not get every form object.
I say Leave It. Good luck.

[Micron]

Highlight the wrong name, which should then propagate into the find & replace dialog. Ctrl+H, choose 'current project' and click either replace or replace all. I don't recommend "replace all' unless you are absolutely sure you have provided the absolute correct 'Find' parameters. Pretty sure that writing code for this would take longer than doing it manually.

[Minty]

If you need to go this route, V-Tools is very good
https://www.skrol29.com/us/vtools.php

It can really globally search and replace.

[ijo68]

As always ..thanks for all the input... still wondering if it's worth all the hassle..