[AccessD] Highlighting a word within a memo field on a form

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 
 

----------------------------------------
> Date: Mon, 26 Jan 2009 09:22:29 -0500
> From: Susan.Klos at fldoe.org
> To: accessd at databaseadvisors.com
> Subject: [AccessD] Highlighting a word within a memo field on a form
>
> 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 
>
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
_________________________________________________________________
Windows Live™: E-mail. Chat. Share. Get more ways to connect. 
http://windowslive.com/explore?ocid=TXT_TAGLM_WL_t2_allup_explore_012009