View Field Codes State in VBA

[phatmankerr2005]

Is there anyway to determine the state of 'View Fields Codes' (as displayed using the Key combination Alt+F9) programatically in VBA and turn it on if it is off. Tried using Send Keys, but as this is a toggle it can all go horribly wrong. I want to combine this with a Multiple Document Search and Replace Macro that I already have (i.e. to allow me to replace field codes as well as body text).

Any ideas would be much appreciated.

 

[earthandfire]

Try

to switch them off:

ActiveWindow.View.ShowFieldCodes = False

and to switch them on:

ActiveWindow.View.ShowFieldCodes = True

Hope this helps.

 

[phatmankerr2005]

EarthandFire,

Worked perfectly, many thanks.

Why is this not in the VBA help file (sorry not another question just a statement).

Thanks again

 

[earthandfire]

I didn't know how to do it.

The easiest way to solve problems like this with VBA in Word, Excel and PowerPoint (doesn't work in Access) is to record a macro to do whatever it is that you need and then take the code that the recorder produces.


Hope this helps.

 

[macropod]

Hi folks,

You can also use the ShowCodes Property for an individual field or for a series of fields via a loop.

Cheers

 

[FaneDuru]

What version of Office do you have?

Fane Duru

 

[macropod]

Office 2000

 

[FaneDuru]

In my case: "ActiveWindow.View.ShowFieldCodes = True" doesn't work (Office 2000). Is there a necessary reference?

Fane Duru

 

[macropod]

Hi FaneDuru,

Try something based on:
ActiveDocument.ActiveWindow.View.ShowFieldCodes = True

For example, the following code snippet gets the current view state, stores it, displays field coding for whatever you want to do, then restores the original state:

Set fcDisplay = ActiveWindow.View
CurrSetting = fcDisplay.ShowFieldCodes
If CurrSetting <> True Then fcDisplay.ShowFieldCodes = True
' Do whatever
fcDisplay.ShowFieldCodes = CurrSetting

Cheers

 

[FaneDuru]

Thanks, I tried it in Excel...that's why it did not work.

Fane Duru