simple copy selection to another field

[wellsw]

This has got to be easy but I cant find the solution anywhere.
I have a form that shows 2 fields from a table.

the first field is "dirty text" and the second is "cleaned text" (one word from Dirty Text)


Basically I have previously attempted to clean extraneous data from the Dirty Text field but a few records are not formatted well enough. What I want the user to be able to do is select the Right word from the Dirty text column with a double click and paste it into the cleaned text column, overwriting whatever was there. I could use a key command to do the actual copy/paste. Basically double click word and hit key.

Any help would be greatly appreciated.

[June7]

Can't have code behind table. I tried double click in textbox event to run DoCmd.RunCommand acCmdCopy and it just errors.

You already have keyboard shortcuts for copy/paste: Ctrl+c and Ctrl+v

Also have right click shortcut for copy/paste - even on table. This is about as fast as moving mouse to click a custom button, maybe faster.