Hello,

I'm fairly familiar with VBA when it comes to Excel, but Access is another story for me.

I have a form ("Contacts") with a simple text box ("AddressCopyBox"). I have a command button underneath the text box. All I want it to do, on Click, is to copy whatever is in the text box.

Suggestions? Many thanks!

Here's a very simple and quick way:

in the click event of the button put:

Me.AddressCopyBox.SetFocus
DoCmd.RunCommand acCmdCopy

Thanks Bob.

Is that code supposed to go in VB? Or just in the command button properties right in MS Access?

I tried to paste it in the properties in Access, and when I clicked the button it said it couldn't find the macro "Me."

Thanks for the quick replies!

VBA Window, where all code goes.

Ok Thanks... I've got it working now.

glad to hear :)