Changing multiple occurrences of column name 1

[LARiot]

Hi.

Thanks in advance for any help.

A table column name was changed. Is there a simple way of changing, at once, all the column names used in the report text boxes? Something akin to the find and replace feature in other apps.

FYI, the control source of the text boxes combine columns and literal strings. E.g.

=[Loss] & "% blah blah blah" & 100 - [Loss] & "% blah blah blah"

-Nima

 

[LARiot]

Apparently if you open the report in design view and click on the save button, the column names change automatically.

Either that or I have magical powers and as unlikely as the latter may be it's the explanation I'm going with.

-Nima

 

[lameid]

You have Track changes and Auto/correct turned on. It will find things in a lot of places but not Modules. As a general recommendation, it sould be turned off for perfrmance reasons. When facing an issue like this, there is some value to turning it on temporarily. Although with time you will tend to make sure you name things the way you want them from the start (although there is always seems to be a change creeping in).

 

[dhookom]

Great comments lameid. Deserves a star.

Duane
Hook'D on Access
MS Access MVP