Well, how are you going about copying it?  You need an Event as a trigger. Is it a button? Is it when the value in the box changes? Is it when the form loads? I see that you're an Expert level student, so you haven't gotten into AfterUpdate events yet in the Developer classes, but that's what I would use.

Hi Richard, I have a populated text box that I want to click on and copy and paste it contents to another text box on the same form so the event is on click.

Thanks

Tom

Is the value already in the field when you click on it? Or do you want to type and then after you're done typing have that value copied? The reason I ask is because unless that value is in the field when the form opens (or when you move from record to record) then you won't be able to access it OnClick. You would have to leave the box (Focus) and then go back to it. It's tricky.

The value will be in the populated text box

This database is populated already. In one section there are a series of products for each site. I have created a blank text box for the one that they choose so I would like to be able to click on one of the populated text boxes and have it copy the contents to the unpopulated text box as the product of choice.

OK. As long as there is already a value in it, you can use OnClick. Let's say your boxes are called Box1 and Box2. In the OnClick event for Box1 all you have to say is:

Box2 = Box1

That's it. When you click on Box1, it's value will be copied into Box2. But you can't start with your focus in Box1, otherwise you would have to click OFF it and then back ON it.

Thank you professor

You're more than welcome. That's what I'm here for. Sometimes I overthink it. Reading your initial question, now it makes sense given the rest of your explanation. I guess in my mind I was just trying to figure out WHY you were doing it that way. But it's a simple solution for what you're trying to do. :)

I was apparently over thinking it also, I was writing VB code to copy and paste it lol

Well, there are clipboard functions you can use to copy and paste selected text. You can change what text is selected. There's all kinds of stuff you can do. But, if you literally just want to click on a text box and have its value copied to another box, that's all you need.

Yes, I was clipboarding everywhere except where I wanted it, lol, as always, I like your solution better thank you again!!!