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.

CoresysAdmin <(E-Mail Removed)> wrote:

>We currently store email addresses in a text field which I wish to change to
>a hyperlink field.

Why do you want to change the field to a hyperlink field?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

In order that when we click on the email address it generates a new email
with the address pre-filled. Currently we are having to cut and paste the
email address in to the new email. If there is a better way of doing this I
am open to suggestions.

Cheers

Michele

"Tony Toews" wrote:

> CoresysAdmin <(E-Mail Removed)> wrote:
>
> >We currently store email addresses in a text field which I wish to change to
> >a hyperlink field.
>
> Why do you want to change the field to a hyperlink field?
>
> Tony
> --
> Tony Toews, Microsoft Access MVP
> Please respond only in the newsgroups so that others can
> read the entire thread of messages.
> Microsoft Access Links, Hints, Tips & Accounting Systems at
> http://www.granite.ab.ca/accsmstr.htm
>

CoresysAdmin <(E-Mail Removed)> wrote:

>In order that when we click on the email address it generates a new email
>with the address pre-filled. Currently we are having to cut and paste the
>email address in to the new email. If there is a better way of doing this I
>am open to suggestions.

You could use the SendObject command in a bit of code behind the form.
Something like
DoCmd.SendObject acSendNoObject, , , me!<name of field on form
containing the email address>

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

Thanks for this - really helpful.

"Tony Toews" wrote:

> CoresysAdmin <(E-Mail Removed)> wrote:
>
> >In order that when we click on the email address it generates a new email
> >with the address pre-filled. Currently we are having to cut and paste the
> >email address in to the new email. If there is a better way of doing this I
> >am open to suggestions.
>
> You could use the SendObject command in a bit of code behind the form.
> Something like
> DoCmd.SendObject acSendNoObject, , , me!<name of field on form
> containing the email address>
>
> Tony
> --
> Tony Toews, Microsoft Access MVP
> Please respond only in the newsgroups so that others can
> read the entire thread of messages.
> Microsoft Access Links, Hints, Tips & Accounting Systems at
> http://www.granite.ab.ca/accsmstr.htm
>