Copying specific cells when on a form

[DesStratos]

Good Afternoon,

I have a database with the personal contact details for all members of staff, mainly viewed from a form showing all their details.

I have 5 separate columns for each persons address and want to create a button on the form that will copy all 5 cells that make up the address for the employee, to be pasted into any other application.

Is the possible? Its been a while since I have written any code for Access and cant remember any of it haha.

Any help would be appreciated.

 

[UncleCatwoman]

[txtFullAddress] = [txtAddress1] & " " & [txtAddress2] & " " & [txtCity] & ", " & [txtState] & " " & [txtZip]