Copy only the selected text to the clipboard, and not the whole field

[vbclueless]

Field called copyfrom is a memo field which could potentially contain a whole long story.
I have a form on which copyfrom is shown, and I want for my user to be able to hi-light only that word/sentence/paragraph that he wants to select, then when he clicks on a button ONLY THAT SELECTION must be copied to a different field, called copyto.

Below is the code I have managed up to this point for the onclick event:
Me!copyfrom.SetFocus
DoCmd.RunCommand acCmdCopy
Me!copyto.SetFocus


DoCmd.RunCommand acCmdPaste

But this copies the entire field and not only the selection. PLEASE HELP! (and note please that I am a novice)

[llkhoutx]

If a random string is selected, you're out of luck with Access. If the string is always in the same position, you can use the Mid function to parce the entire field.

Maybe you can use Google to find an API that will accomplish what you want.