Email address display

[Michael C C G]

Hi,

When I type an email address into a form the underlying table displays the
address but appends appends a full hyperlink address to it. How can I
prevent this?

Thanks

 

[Arvin Meyer [MVP]]

The hyperlink datatype defaults to the http protocol. You can force it to
email by prepending "mailto:" to the email address. I find it easier and
much more efficient to simply use a text datatype and code to prepend when I
want to email something:

Private Sub txtEmail_DblClick(Cancel As Integer)
Me.Application.FollowHyperlink ("Mailto:" & Me![txtEmail])
End Sub