Turning a field into a hyperlink?

[Haynesey]

We have an email address field on our database. Is their a way make this field a hyperlink to pick up the address entered in the field?

Thanks
Lee

 

[Fornatian]

Set the OnClick event to:

Application.FollowHyperlink Me.FieldNameToFollow

or:

Application.FollowHyperlink "mailto:"& Me.FieldNameToFollow



Also set the hyperlink address to "" which makes the little hyperlink hand show as I learnt from another user on this forum, very professional and user friendly.