Programmatically creating email (hyperlink) - BUG?

[Guest]

Okay,

I have a procedure which creates automatically a email address out of a
filled in sur- and lastname. Everything works great, but there's one problem.

The email-field is a hyperlink, because this allows me to click on it, and
it automatically fires up my Outlook Email-editor.

The problem: when I create the email manually in the "Users", table, and i
click on the manually created email, the Outlook Email-editor opens up. When
I programmatically create the email on a form (in an AfterUpdate event), the
email gets filled in correctly, but when I click on it, nothing happens (at
which point it should launch my Outlook email editor)... The strange thing is
that when i click on the newly created email address in the form, i can use
my right mouse button, and choose "Edit Hyperlink", which works, and the
email address is filled in. And still it doesn't work..

BTW: I'm working with Access 2007

Any suggestions...?

 

[Guest]

Okay,

This is not a bug, rather a 'feature' from the Hyperlink field. Access
assumes default the HTTP (Web) protocol, and not the SMTP (Email) protocol
when programmatically creating email addresses. One way to do this:

see
http://support.microsoft.com/default.aspx?scid=kb;en-us;323202&Product=acc2000 for more information on the Microsoft MSDN Website.