New table supplied for old report and must change field names.

[Bigby3]

Hey all,

I have a report that is used each year to summarize a bunch of data. It contains about 100 text boxes with assorted calculations taking place in box.

The problem is this year we have been supplied with a different table which has different (but similar) field names. I have to revise the report as all data will come to us in this format from now on. Is there a way to find and replace each occurrence of the field names that have changed in each of the text boxes? I can do it manually, but I have several reports that I'd have to change and would like to automate it as much as possible. Thanks for any suggestions.

 

[Pat Hartman]

Access doesn't include any tools that will help you. You might try Speed Ferret by Black Moyshan.

 

[Bigby3]

I found a shareware tool from Rick Fisher Consulting (www.rickworld.com) called Find and Replace 9.0. It gives great find and replace functionality for all sorts of Access controls in tables, reports, etc. Thanks for the suggestion.