Display Text vs URL when Entering Hyperlinks

J

James

I have a form with a textbox that populates a field in a table. I
enter email addresses in it. Initially, I wanted to be able to click
on the text in the textbox and launch an email to that address, so I
did some searching and came up with this KB article 323202
(http://support.microsoft.com/default.aspx?scid=kb;en-us;323202).

I used their code at the bottom:

If Len(Me![Text0]) = 0 Then Exit Sub
Me![Text0] = "#mailto:" & Left(Me![Text0], InStr(1, Me![Text0], "#") -
1) & "#"

Here's my problem. The link works, but the textbox now contains
something to the effect of mailto:[email protected]. I only it to
display ther actual email address ([email protected]). Can I do this
and retain the hyperlinked ability at the same time?

Thanks,

James
 
Top