email addresses in a database

[David Robinson]

When I enter an email address into an Access data field, I would like to be
able to click on the field and have the Outlook Express email screen pop up.
Unfortunately whatever I do it calls the Internet browser, inspite of the
fact that a field containing name@isp is obviously not a url but an email
address. We do not have this problem with Excel or Word. How can I declare
a field to be of type "hyperlink" and have it automatically insert the
string "mailto:" rather than "http://"?

I tried creating an additional text box on a form, declare it of type
hyperlink, and construct the necessary string built up by
[emailaddress]&"#"&"mailto:"&[emailaddress], but this doesn't work either.

Can anyone help me over this?

David Robinson

 

[Jeff Boyce]

David

Don't bother! Don't bother to declare it as a hyperlink field. Instead,
call it "text". Then, in the control's Dbl-Click event, use the SendTo
function to launch your emailer, using the text (i.e., the email address).

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

 

[fredg]

When I enter an email address into an Access data field, I would like to be
able to click on the field and have the Outlook Express email screen pop up.
Unfortunately whatever I do it calls the Internet browser, inspite of the
fact that a field containing name@isp is obviously not a url but an email
address. We do not have this problem with Excel or Word. How can I declare
a field to be of type "hyperlink" and have it automatically insert the
string "mailto:" rather than "http://"?

I tried creating an additional text box on a form, declare it of type
hyperlink, and construct the necessary string built up by
[emailaddress]&"#"&"mailto:"&[emailaddress], but this doesn't work either.

Can anyone help me over this?

David Robinson

Just use a regular Text datatype field.

Using a form, enter the address as you normally would,
(e-mail address removed)

Code the control's Double-click event:
Application.FollowHyperlink "MailTo:" & [ControlName]