Go Back   Access World Forums > Microsoft Access Discussion > Reports

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 08-24-2016, 01:01 PM   #1
kingdoz
Newly Registered User
 
Join Date: Dec 2008
Location: LA with holiday apartment in San Fran
Posts: 27
Thanks: 1
Thanked 0 Times in 0 Posts
kingdoz is on a distinguished road
Find Replace text box text in multiple reports

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

kingdoz is offline   Reply With Quote
Old 08-24-2016, 01:20 PM   #2
jdraw
Super Moderator
 
jdraw's Avatar
 
Join Date: Jan 2006
Location: Ottawa, Ontario, Canada;West Palm Beach, Florida
Posts: 12,142
Thanks: 81
Thanked 2,010 Times in 1,958 Posts
jdraw is a glorious beacon of light jdraw is a glorious beacon of light jdraw is a glorious beacon of light jdraw is a glorious beacon of light jdraw is a glorious beacon of light
Re: Find Replace text box text in multiple reports

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
__________________

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
jdraw is offline   Reply With Quote
The Following User Says Thank You to jdraw For This Useful Post:
kingdoz (08-24-2016)
Old 08-24-2016, 01:28 PM   #3
kingdoz
Newly Registered User
 
Join Date: Dec 2008
Location: LA with holiday apartment in San Fran
Posts: 27
Thanks: 1
Thanked 0 Times in 0 Posts
kingdoz is on a distinguished road
Re: Find Replace text box text in multiple reports

Thanks for the quick reply. I will give it a try and report back. Thanks again.

kingdoz is offline   Reply With Quote
Old 08-24-2016, 01:48 PM   #4
kingdoz
Newly Registered User
 
Join Date: Dec 2008
Location: LA with holiday apartment in San Fran
Posts: 27
Thanks: 1
Thanked 0 Times in 0 Posts
kingdoz is on a distinguished road
Re: Find Replace text box text in multiple reports

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

kingdoz is offline   Reply With Quote
Reply

Tags
bulk , find replace , form , reports

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
fInd and replace text across many text boxes in report design RW_ECC Reports 2 01-30-2015 08:11 AM
Replace text in entries on forms and reports wubbi Queries 1 04-04-2012 07:46 AM
Custom find and replace to alter text in a field secondangel Modules & VBA 2 02-19-2009 02:57 PM
Find and Replace text cdoyle General 1 08-03-2006 11:39 AM
Find and replace text in table mike wild Modules & VBA 12 04-07-2004 03:19 PM




All times are GMT -8. The time now is 07:46 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World