font of word bookmarks

[emilylu3]

Hi i am inserting text from access into a word.doc And I need it to be a certain font color



With objWord.ActiveDocument.Bookmarks
ActiveDocument.Bookmarks_ ("A").Range.Font.Shading.BackgroundPatternColor = wdColorBlue
.Item("A").range.Text = "test"
End With

This doesn't work, anyone familiar with this font stuff

[StepUP]

Why are you referencing the Bookmarks collection?

The best way to do this is to go into Word and record a macro. Then copy the code from the macro. For example:

ActiveDocument.Range.Font.Color = wdColorBlue