Global find & replace in formulas?

  • Thread starter Thread starter Jerry Crosby
  • Start date Start date
J

Jerry Crosby

I have a report with a number of calculated controls with a DLookUp
statement in them. I need to change the name of the table where the DLookUp
is doing it "D-Looking Up." Is it possible to do a "find and replace"
rather than to manual open each control and manually make the change?
 
"Speed Ferret", more info at http://www.moshannon.com; and "Find & Replace",
more info at http://www.rickworld.com, are third-party tools for global find
and replace in Microsoft Access (and Speed Ferret also handles other
software, as well).

The "Name Autocorrect" feature of Access, if turned on, may do what you want
depending on the circumstances... which are not clear from your description.
If you are renaming an existing table, the Name Autocorrect feature will
modify _most_ uses of that name to match the revised name. CAUTION: Name
Autocorrect can cause
"issues" in other areas, so many people would rather use another approach!

Larry Linson
Microsoft Access MVP
 
Back
Top