Email Property

[Karen]

How do I set the global property of a textfield on a form
so that if an Email address is added when I click it
takes me direct to Outlook.

I have tried setting the field property to HTML YES in
design mode - this allows me to edit to a email address
in form mode - this will then go direct to outlook.

BUT I would like to set the field so that all records are
the same, otherwise I would need to edit each individual
record and edit any new records.

If anyone can help I would much appreciate it

Karen

 

[Rick Brandt]

How do I set the global property of a textfield on a form
so that if an Email address is added when I click it
takes me direct to Outlook.

I have tried setting the field property to HTML YES in
design mode - this allows me to edit to a email address
in form mode - this will then go direct to outlook.

BUT I would like to set the field so that all records are
the same, otherwise I would need to edit each individual
record and edit any new records.

If anyone can help I would much appreciate it

As long as your using a form I would drop the hyperlink field and just
store the Email address in a plain text field. Then you can use SendObject
or automate a messaging library to create an Email while automatically
inserting the address into the "To" of the message. SendObject example
below.

DoCmd.SendObject , , , Me!EmailFieldName