Access 2003, Copy selected field to clipboard

Posted on 2009-02-17
Last Modified: 2013-11-28
Hey experts,
I would like to add a button to my form that would copy all the test of a specied field to the clipboard. Is there a simple way I can do this?

Table name: Dispute
Field Name: Reason
Form name: fDispute
Question by:ggodwin
    LVL 74

    Accepted Solution


        DoCmd.RunCommand acCmdCopy

    Author Comment

    Thanks for the support on this item.

    For anyone reading this in the future here is my actuall code behind button for my "On-Click" event.

    Just to be complete:
    ResonforRequest is the name of my textbox and I replace "yourTextbox" with my name.

    Private Sub CopyTextbox_Click()
    On Error GoTo Err_CopyTextbox_Click
        DoCmd.RunCommand acCmdCopy
        Exit Sub
        MsgBox Err.Description
        Resume Exit_CopyTextbox_Click
    End Sub

    Open in new window

    LVL 74

    Expert Comment

    by:Jeffrey Coachman

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
    Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
    As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
    In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now