Klos, Susan
Susan.Klos at fldoe.org
Mon Jan 26 12:07:55 CST 2009
Thank you, Jim. The database is in 2007 so I am going to try this tonight. Mark, I think I will try Jim's suggestion first. If I need more I will let you know. Thanks. If you need further assistance feel free to contact me. Susan Klos Senior Database Analyst Florida Department of Education Evaluation and Reporting Office Phone: 850.245.0708 email: susan.klos at fldoe.org Message: 5 Date: Mon, 26 Jan 2009 09:22:29 -0500 From: "Klos, Susan" <Susan.Klos at fldoe.org> Subject: [AccessD] Highlighting a word within a memo field on a form To: <accessd at databaseadvisors.com> Message-ID: <D78B10E8D3277D42B76BD76569E52417168963B6 at MAIL2.FLDOE.INT> Content-Type: text/plain; charset="us-ascii" I am working with a missionary who is translating the Bible into a foreign language. I have 3 forms-one main form, with a sub-form which also has a sub-form. The sub sub-form has a reference to a Bible verse and then the Bible verse written in the foreign language. The Bible verse is a memo type field because the length is too long for a text field. He wants to be able to underline or highlight key words within the verse. Any ideas how to do this? Susan Klos Senior Database Analyst Florida Department of Education Evaluation and Reporting Office Phone: 850.245.0708 email: susan.klos at fldoe.org <mailto:susan.klos at fldoe.org> ------------------------------ Message: 6 Date: Mon, 26 Jan 2009 09:08:14 -0600 From: "Hewson, Jim " <JHewson at nciinc.com> Subject: Re: [AccessD] Highlighting a word within a memo field on a form To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> Message-ID: <7E02B06E41E5404589EDDDA2BAA1C5A83EC7DC at sanex101.nciinc.com> Content-Type: text/plain; charset="us-ascii" Which version are you using? In A2007, the Memo field text format can be set to Rich Text, which will allow bold and underlining. In previous versions, the use of a third party add-in is required, such as FMS Total Access Memo. I've used the FMS product for A2000 and it works well. Jim Message: 9 Date: Mon, 26 Jan 2009 15:59:46 +0000 From: Mark A Matte <markamatte at hotmail.com> Subject: Re: [AccessD] Highlighting a word within a memo field on a form To: <accessd at databaseadvisors.com> Message-ID: <COL118-W434BE3EB39EB96BF829F9DD2CA0 at phx.gbl> Content-Type: text/plain; charset="Windows-1252" I had 1 request from the Legal dept to do this with one of my reports....very crude...but worked for me... It takes data from a memo field and puts into an OLE Object 1 chunk at a time. It Searches the memo field...finds my search text...inserts the text prior to the Search text...then inserts and formats/Color/Highlights the search text. Then inserts the next chunk of data up to the next instance of the Search text. I had some issues setting the highlight properties, can't remember why...but that is why the next step seems backwards. I then re-format the just inserted chunk(un-highlight) Keep doing this until I'm out of data. As I said very crude...but It met my needs...and this group helped get there, so... If you want I can post the code. Thanks, Mark A. Matte ****************************