Macro window: Is it possible to make global text changes?

[jonnysnow]

I have a long macro that sets many control properties, based on many conditions. Examples of conditions are:

[Reports]![rptCVD]![Flag] = 0
[Reports]![rptCVD]![Flag] = 1
[Reports]![rptCVD]![Flag] = 2
[Reports]![rptCVD]![Flag] = 3

Examples of actions are to SetValue for the following:

Item Expression
[Reports]![rptCVD]![Label1].[Visible] True
[Reports]![rptCVD]![Label2].[Visible] True
[Reports]![rptCVD]![Label1].[Visible] False
[Reports]![rptCVD]![Label2].[Visible] False [Reports]![rptCVD]![Label1].[FontSize] 10
[Reports]![rptCVD]![Label2].[FontSize] 10 [Reports]![rptCVD]![Label1].[Color] Red
[Reports]![rptCVD]![Label2].[Color] Blue


These are all just examples, but I'm sure you get the idea.

Suppose I want to change all occurrences of [rptCVD] to [rptSortregion] or all occurrences of [Label1] to [IDlabel]. Is there an easy way to make these global text changes from the Macro window? Maybe from outside the Macro window???

 

[mp9]

I'm not sure that there's an easy way to do this from within native Access. However, there are commercially available products that let you do this - I've used Speed Ferret from Black Moshannon (

http://www.moshannon.com)

in the past. Unfortunately for us all, this costs!

Hope this helps.

http://www22.brinkster.com/accessory/

 

[jimlee]

i may be on the wrong track here, but when you talk about the macro window, do you actually mean the code window (as in VBA code).

If so, try

http://www.mztools.com,

download the add-in and install, then use it's find function... it lets you 'replace all'. Hope this helps.

jimlad