acCopy

[kennytwk via AccessMonster.com]

hi,

how do i copy a value from a textbox (text0) to the clipboard when i click on
a command button.

DoCmd.MenuItem ....., acCopy

That's as far as i know, can someone enlighten me?

 

[John Nurick]

Hi Kenny,

First you need to return the focus from the commandbutton to the
textbox. If you use

Screen.PreviousControl.SetFocus

it will go back to whatever control had the focus before you clicked the
button, which means you can use the same button to copy the contents of
more than one control. Then use

DoCmd.RunCommand acCmdCopy

rather than the archaeological DoCmd.MenuItem.

 

[kennytwk via AccessMonster.com]

Hi,

Thanks, your code works