Copy form field data to clipboard

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Delta - 26 Apr 2007 15:50 GMT

I have set the field I want to have focus and then wish to copy the data to
the clipboard. Can someone help me with the code for this.

Forms!frmExhibitorInfoVerification!Email.SetFocus

Signature

Entering the world of VBA and coding
Delta

Reply to this Message

Allen Browne - 26 Apr 2007 15:56 GMT

If the desired field has focus, use:
RunCommand acCmdCopy

If you need to manipulate strings first (e.g. combinating data from several
fields), it's more complex:
http://allenbrowne.com/func-07b.html

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

>I have set the field I want to have focus and then wish to copy the data to
> the clipboard. Can someone help me with the code for this.
>
> Forms!frmExhibitorInfoVerification!Email.SetFocus

Reply to this Message

Dennis - 26 Apr 2007 16:00 GMT

Don't know if this is the best way but it works

DoCmd.DoMenuItem acFormBar, acEditMenu, acCopy

> I have set the field I want to have focus and then wish to copy the data to
> the clipboard. Can someone help me with the code for this.
>
> Forms!frmExhibitorInfoVerification!Email.SetFocus

Reply to this Message