Converting Hyperlink field back to short text

[gksmith5]

In a customer Access table, I have a field for customers' email addresses. The field type was originally Short Text. In order to send email messages, I changed the data type to Hyperlink. Now, I wish to convert the field back to Short Text, but I have discovered that upon doing the conversion, the field contents have been modified by adding "#mailto:email address" to the end of the original email address. How do I delete this extra information? I want to insert only the original email address via Mail Merge into a Word document. This extra information is redundant. Before doing this conversion of the field types, I was able to insert the email addresses into my Word documents as desired without the added verbiage.



Thanks in advance!

[isladogs]

This situation is the reason why many of us avoid the hyperlink datatype
If you want to remove the 'verbiage' permanently, then use an update query.
Update your email address field to

left([emailaddress],InStr([emailaddress],"#mailto")-1)

Make a backup first just in case

BTW welcome to the forum

[gksmith5]

I have learned my lesson regarding use of Hyperlinks in Access! Thanks for the help.

[isladogs]

You're welcome.