[AccessD] AccessD Digest, Vol 71, Issue 36

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 
 

****************************




More information about the AccessD mailing list