Form Field data selected, how do I deselect in a macro

[mchadwick]

Field 1= Bobisyour\Uncle\ (this text was pasted into this field)
Field 2= WhoIsBob (This field comes from another field and is now in the clipboard)

I am going to field 1 and pasting this information "Bobisyour\Uncle\" then using gotocontrol I goto field 2 and copy the text into the clipboard "WhoIsBob". Then using gotocontrol I go back to field 1 and paste "WhoIsBob" at the end of the existing text and ending up with "BoBobisyour\Uncle\WhoIsBob". I do not know how to go to the end of the text in the field to paste the new text from field 2. When I enter the field the text it is always automatically selected, I want to deselect it automatically and go to the end of the text. I can manually go to the end of the text by simply clicking at the end of the text and then pasting, but would rather automate it in a macro.

[ranman256]

'Just take the two values and re-assign

txtField2.setfocus
DoCmd.RunCommand acCmdPaste     'paste the value

txtField1 =txtField1 & txtField2

[mchadwick]

This worked perfectly, thank you very much. I would like to move the focus to another field in the form. Instead of creating a macro to do that I thought I would ask for the code and just put in this Event procedure. Im in field1 and I want to go to Field2