Find Replace text box text in multiple reports (1 Viewer)

kingdoz

Registered User.
Local time
Today, 03:52
Joined
Dec 2, 2008
Messages
29
Hi all. I have been trying to find a solution to avoid doing this manually but can't seem to find a way in Access 2013 or 2016.

I have hundreds of reports (used for mailing different letters), and I need to do a find/replace on all instances where the report contains the text box ="Yours Faithfully" to replace to ="Yours Sincerely" without manually opening 300+ Reports and manually changing them.

Any suggestions would be helpful.

Thanks
 

jdraw

Super Moderator
Staff member
Local time
Yesterday, 22:52
Joined
Jan 23, 2006
Messages
15,379
I think v-Tools (free utility) has an option, but it's been a long time since I've used it for anything.

You want total deep search with replace
 

kingdoz

Registered User.
Local time
Today, 03:52
Joined
Dec 2, 2008
Messages
29
Thanks for the quick reply. I will give it a try and report back. Thanks again.
 

kingdoz

Registered User.
Local time
Today, 03:52
Joined
Dec 2, 2008
Messages
29
Well it did work and changed 3 or 4 reports, but didn't work fully for me. After wondering why it only found and replaced 3 reports after opening the lot, I now realise that the vast majority of my reports have bound Word docs in there with that text, so have to find another solution now again. Oh well. At least I know the solution when it's not bound docs in a report :)
 

Users who are viewing this thread

Top Bottom