[AccessD] MS Word Highlight Problem

Max Wanadoo max.wanadoo at gmail.com
Thu Mar 11 18:37:51 CST 2010


Robert,

I would change the len(mstrbidname)  bit  to  constant 7.

You know how long "Bidname" is but you don't  know how long len(mstrbidname)
is.

So it would read:

If Left(myBookmark.Name, 7) = "BidName" Then
  myBookmark.Range.HighlightColorIndex = wdDarkYellow
End If

Max
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Robert
Sent: Thursday, March 11, 2010 11:05 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] MS Word Highlight Problem

Could anyone give me some clues as to why this code does not work? Trying to
highlight a text string contained in a bookmark. No errors are thrown,
simply doesn't work?


            For Each myBookmark In objword.ActiveDocument.Bookmarks
              If Left(myBookmark.Name, Len(mstrBidName)) = "BidName" Then
                 myBookmark.Range.HighlightColorIndex = wdDarkYellow
              End If
            Next myBookmark

WBR
Robert


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list