We currently store email addresses in a text field which I wish to change to a hyperlink field. If I change the field type to hyperlink and use the following code on the form field this works perfectly for new addresses that are input. Private Sub Tut_Email2_AfterUpdate() Me![Tut_Email2] = Me![Tut_Email2].Text & "#" & "MailTo:" & Me![Tut_Email2].Text End Sub However, all of the existing data registeres as http://. Is their a way of updating all of the currently stored email addresses to change them to 'mailto' rather than 'http://'. I have tried various update queries without success.