Strip data in clipboard to text only so that it may be pasted into memo field

[Andy_Khosravi]

I have a form with a large memo field that is designed to hold lengthy
comments. There are times when my users need to paste in e-mails
directly into the comment box. This works fine unless their e-mail
contains attachments, pictures, etc. In the event that their copy
action captured something other than text than nothing happens when
they try and paste into the comment field.

I considered handling this with an imbedded OLE object, but the
application already houses 10,000 comments, and will eventually house
around 30-40k in the near future. My thoughts are that this would be
way too big.

I'm wondering if there would be a method to 'clean' the object in the
clipboard so that it contained only text. I'm guessing this would
require some sort of API call, but I'm not sure how to go about making
something like that. I was wondering if anybody had seen some existing
code that did something similar.

I am currently using A97 with Win2k. In about a month we are scheduled
to all have Win XP with Office 2003, and already half of the users
using this have the upgraded version. I am not sure if this newer
version of Access will provide additional tools to make this easier.

Thanks in advance

-Andy

[person]

On 31 Oct 2006 15:37:28 -0800, An***********@bcbsmn.com wrote:

>I have a form with a large memo field that is designed to hold lengthy
comments. There are times when my users need to paste in e-mails
directly into the comment box. This works fine unless their e-mail
contains attachments, pictures, etc. In the event that their copy
action captured something other than text than nothing happens when
they try and paste into the comment field.

I considered handling this with an imbedded OLE object, but the
application already houses 10,000 comments, and will eventually house
around 30-40k in the near future. My thoughts are that this would be
way too big.

I'm wondering if there would be a method to 'clean' the object in the
clipboard so that it contained only text. I'm guessing this would
require some sort of API call, but I'm not sure how to go about making
something like that. I was wondering if anybody had seen some existing
code that did something similar.

I am currently using A97 with Win2k. In about a month we are scheduled
to all have Win XP with Office 2003, and already half of the users
using this have the upgraded version. I am not sure if this newer
version of Access will provide additional tools to make this easier.

Thanks in advance

-Andy

Take a look at
http://vb.mvps.org/articles/ap200106.asp

if you read in in text mode that should work.

[Andy_Khosravi]

Take a look at
http://vb.mvps.org/articles/ap200106.asp

if you read in in text mode that should work.

Thanks for the link, I'll page through that and see if I have any luck
interpreting it.