I created a field in access form to enter an email address. How can I make
it automatically when I double click the email address I entered on the form
field the email address goes to Microsoft outlook email address form.

Rose

One approach would be to add some code to the DoubleClick event. In that
code, you'd add something like:

"mailto:"

on in front of the email address in your control on the form, then follow
the hyperlink.

The code could be as simple as:

Application.FollowHyperlink "mailto:" & Me![YourControl].Text

(use your control's name).

Regards

Jeff Boyce
<Office/Access MVP>

"Rose" <(E-Mail Removed)> wrote in message
news:8852CE75-F06A-4CF0-A3ED-(E-Mail Removed)...
>I created a field in access form to enter an email address. How can I make
> it automatically when I double click the email address I entered on the
> form
> field the email address goes to Microsoft outlook email address form.

Hi Jeff,
I have one more question. What is my control's name?

Thanks


"Jeff Boyce" wrote:

> Rose
>
> One approach would be to add some code to the DoubleClick event. In that
> code, you'd add something like:
>
> "mailto:"
>
> on in front of the email address in your control on the form, then follow
> the hyperlink.
>
> The code could be as simple as:
>
> Application.FollowHyperlink "mailto:" & Me![YourControl].Text
>
> (use your control's name).
>
> Regards
>
> Jeff Boyce
> <Office/Access MVP>
>
> "Rose" <(E-Mail Removed)> wrote in message
> news:8852CE75-F06A-4CF0-A3ED-(E-Mail Removed)...
> >I created a field in access form to enter an email address. How can I make
> > it automatically when I double click the email address I entered on the
> > form
> > field the email address goes to Microsoft outlook email address form.
>
>
>

"Rose" <(E-Mail Removed)> wrote in message
news:E73293F2-F08D-4661-B5C6-(E-Mail Removed)...
> Hi Jeff,
> I have one more question. What is my control's name?

The Control is the box (of whatever type) on the Form, in which data is
displayed. Right-click the Control and Choose properties, and you'll see the
name of the Control as the first line in the Other tab of the Property
Sheet.

Can I suggest, at this level of question, that you (1) either purchase a
book aimed at novice users (Microsoft Access Step by Step, from Microsoft
Press, is a good one, and there are many others including Microsoft Access
Inside Out by John Viescas, also from Microsoft Press) and a little study to
learn the very basics or (2) you visit Office Online at
http://office.microsoft.com and look in the list that follows "Home" on the
left side of the page, follow the "Training" link and go through some,
better yet, all, of the very good online training courses for Access.

Larry Linson
Microsoft Access MVP

it works thanks for your help...

rose

"Larry Linson" wrote:

>
> "Rose" <(E-Mail Removed)> wrote in message
> news:E73293F2-F08D-4661-B5C6-(E-Mail Removed)...
> > Hi Jeff,
> > I have one more question. What is my control's name?
>
> The Control is the box (of whatever type) on the Form, in which data is
> displayed. Right-click the Control and Choose properties, and you'll see the
> name of the Control as the first line in the Other tab of the Property
> Sheet.
>
> Can I suggest, at this level of question, that you (1) either purchase a
> book aimed at novice users (Microsoft Access Step by Step, from Microsoft
> Press, is a good one, and there are many others including Microsoft Access
> Inside Out by John Viescas, also from Microsoft Press) and a little study to
> learn the very basics or (2) you visit Office Online at
> http://office.microsoft.com and look in the list that follows "Home" on the
> left side of the page, follow the "Training" link and go through some,
> better yet, all, of the very good online training courses for Access.
>
> Larry Linson
> Microsoft Access MVP
>
>
>