fInd and replace text across many text boxes in report design

RW_ECC

New member
Local time
Today, 02:56
Joined
Nov 26, 2013
Messages
5
Is it possible to use find and replace to modify text in report design - or else is there something else I can do to get the same effect?
I have a really useful report and I want to modify it for use with a different dataset. To do that I will need to change the text in over 150 text boxes. I have seven different fields which each occur over 20 times in the control source formulas in the text boxes, because they are used in different ways in different calculations. If this was excel I could do a simple find and replace to change e.g. every reference to fieldname OLD to fieldname NEW, but I cannot see how to do that within access report so am haveing to click on each text box in turn, go to properties and edit the text box .
I am trying to switch to a more general naming system in the modified report so then I will be able to assign data with the required fieldnames for the report within a query. But the report I am starting with has field names based on years 2013, 2014, 2015 etc so would get really confusing to keep those names, hence I want a quick way to change each reference to those field names to my more generic new field names.
 
Data encoded in field names (instead of being stored in the fields themselves) is a breach of data normalization with the ensuing PITA. You may want to redesign the thing - not to make it easy to change names but to obviate the need for doing so altogether. Show your data structure - screenshot of the Relations window
 
NOt entirely sure I understand what you mean, but it gets me no further to knowing whether there is any quicker way to edit bits of report. I have done it manually in the time waiting for any help now.

This is the kind of thing I have in Control Source of text boxes:
=Sum([SumOfPAN]*IIf([year]=2014,1,0))

I wanted to change field year to a different one yearcode.
I wanted to change 2014 to 0.

I had over 100 similar things to edit and wanted to do find and replace or similar to do it quickly, but had to edit one by one as could not find another way.
 

Users who are viewing this thread

Back
Top Bottom