Julie A. Alley
juliea at eccs-seattle.com
Thu Mar 13 07:42:00 CST 2003
I am using the following code to send a report to Word, then conduct a search and replace for the search phrase used to create the report. The problem: This only works once, then I have to reboot in order for it to work again.... Any one know a reliable way to do this repetitively? Search, send results to word, then bold the search phrases. Thanks, DoCmd.RunCommand acCmdOutputToRTF With Selection.Find .ClearFormatting With .Replacement ' .ClearFormatting .Font.Name = "Arial" .Font.Size = 24 .Font.AllCaps = True .Font.Bold = True End With .Forward = True .Wrap = wdFindContinue .Execute FindText:=strCriteria(0), _ Replace:=wdReplaceAll, ReplaceWith:=Trim(strCriteria(0)) End With Julie Alley Emerald City Computer Solutions, Inc. <mailto:Juliea at eccs-seattle.com> Juliea at eccs-seattle.com Cell: 206-235-0954 Office: 206-932-6618 Fax: 206-938-7941 Web site: <http://www.eccs-seattle.com/> http://www.eccs-seattle.com WARNING: The information contained in this e-mail is confidential. The information is intended only for the use of the individual or entity to whom it is addressed. If you are not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any use, dissemination, distribution or copying of this communication is strictly prohibited. If you have received this e-mail in error, please immediately notify us by a collect telephone call to 206.932.6618 and return the original message to us by e-mail. Thank you. -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030313/dce99fcf/attachment.html>