Copy field contents using DblClick action

[lwwhite]

(Access 2003) Here's what I want to do: enable users to double-click a field in a datasheet-view subform and thereby save the contents of that field to the Windows clipboard so that they can then paste it into another field. I tried to set it up as a DblClick event on the field with this syntax:

DoCmd.DoMenuItem acFormBar, acEditMenu, acCopy, , acMenuVer70

However, when I tested, I got a message that the Copy action wasn't available. So then I changed it to a KeyDown event, meaning users have to double-click THEN press a key to copy the data. This works, but I'd really like to copy with just a double-click.

What am I missing?

[NeoPa]

I would guess that it only works when the field you want is the active control.
I never use macros so this is not an area I understand very well.

[missinglinq]

The Copy Action wasn't available because you had no text selected to copy! This code sets the cursor to the beginning of the text box, selects all of the text and then carries out your copy action:

Private SubYourTextBoxName_DblClick(Cancel As Integer)
    Me.YourTextBoxName.SelStart = 0
    Me.YourTextBoxName.SelLength = Len(Me.YourTextBoxName.Value)
    DoCmd.DoMenuItem acFormBar, acEditMenu, acCopy, , acMenuVer70
End Sub
 

Tested in Access2000.

[NeoPa]

Thanks ML for covering my arse.
Good answer.