Clickable email link in rich text memo field textbox

[isladogs]

Hi

Does anyone know how to correctly make a clickable email link in an Access rich text box for a memo field?

Background:
To create a clickable URL link in a rich text box for a memo field you use something like this:

<a href="http://www.bbc.co.uk">www.bbc.co.uk</a>

This of course will be shown as www.bbc.co.uk

The equivalent for email SHOULD be:

<a href="mailto:xyz@btinternet.com">xyz@btinternet.com</a>

This displays 'xyz@btinternet.com' (without the quotes) but isn't a clickable link

However if you add mailto: to the displayed part like this:

<a href="mailto:xyz@btinternet.com">mailto:xyz@btinternet.com</a>

you get a clickable link but its shown as mailto:xyz@btinternet.com
This could confuse people as it implies 'mailto:' is part of the address ...!

How to solve? Any ideas?

NOTE: Also posted here: http://www.utteraccess.com/forum/index.php?showtopic=2045314

 

[arnelgp]

Lol, somebody out there will catch you of double posting.

 

[isladogs]

That's why I've stated that I've double posted and provided the links both here ... and there!

 

[isladogs]

For info this is the form I was trying to fix

The issue was the email line in the top section

I've solved it by reverting to using plain text textboxes for the top section and using Application.FollowHyperlink code for the 3 links