General :: Copying Hyperlink As Text

I need to get an email address from a field and place it onto another form.. HOWEVER I dont want it as a hyperlink, nor do I want the mailto blah blah coming over.. I just want the email address as TEXT.In the application the user opens the email form by clicking an icon on an invoice screen, this will allow them to automatically email to the client.. Once they open the email screen they naturally see an arrangement of other boxes where they can enter subject, email description etc..

At the same time there are two boxes, the "To" box and the"From" box... I want these boxes to be auto updated with the email address (to save time). When the user clicks the icon on the invoice screen it automatically copies and displays the email address of the client in the "To" box on the invoice.. The problem I am having is that it is displaying as useless information which is associated with the hyperlink.The email address comes from a field that has already previously been associated as a hyperlink, and it HAS to come from this field, I have no way around it.... All of this information is coming from an address book section from a field that is a hyperlink field.. If it was a txt field then I would not be having this problem.

As I already have various forms open displaying information I am able to used simple code to fill in various bits of info to save time... Because of this I am using simply code to copy the email address from one form to another:

Forms![Email]![To] = Forms![AddressBook]![Email]

Obviously the above code is simple and works for 90% of this type of approach, however there must be some other code that I need to use to first translate the email address to text...

In the end I don't care what I have to do as long as it works.. Remember though that the original field is a hyperlink field and must remain so, I cannot simply convert that to txt..