Set Value of control to contents of clipboard

[raygunc]

I've tried searching for the answer but not resolved this problem.

Is it possible to set the value of a control (text box) to the contents (text) of the clipboard.

I want my form to have a button on it that the user presses to paste the contents of the clipboard into the control. I appreciate there is already a paste button on the toolbar but I wanted something close to the control specific for this task.

I've tried:

me!txtCtrl=acpaste

However, instead of the expected text I get a number

I assume I'm missing a step somewhere

Any ideas please?

Developed using Access97 only

Ta

Ray

 

[RoyVidar]

try

[tt]me!txtCtrl.setfocus
docmd.runcommand accmdpaste[/tt]

Roy-Vidar

 

[raygunc]

Brilliant

Thanks Roy - works a treat!

Ray