Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Hyperlinks on Forms for email address

Discussion in 'Information Technology' started by IanL, Jul 28, 2006.

  1. IanL

    IanL
    Expand Collapse
    Guest

    I have a textbox on a form that is linked to a hyperlink field.

    The field is used to input email addresses. However the hyperlinks don't
    work because access prefixes them with http:/ (instead of mailto:).

    I can not find anywhere in the field or the text box to set this property.
    So that access knows they are email addresses.

    Please Help!
     
  2. Loading...

    Similar Threads Forum Date
    USA Akaal Takhat Forms Committee to Represent US Sikhs Breaking News Sep 13, 2013
    India Poll reforms on crash course Breaking News Sep 7, 2013
    General A Conversation about the Grammatical Forms of Raam and Simran Hard Talk Dec 1, 2011
    India Anna Says Fast Only "Suspended", Wants Electoral Reforms Breaking News Aug 28, 2011
    India India Announces $5 bn Aid for Africa, Seeks Support for UN Reforms Breaking News May 24, 2011

  3. Allen Browne

    Allen Browne
    Expand Collapse
    Guest

    You can right-click the address, and manually fix it by changing the
    hyperlink part so it has the "mailto:" prefix.

    Realistically, that proves to be a very inefficient approach. I much prefer
    to use a Text field, which avoids the problem and also saves users getting
    confused between whether they changed the display address or the actual
    address or both.

    You can still make it look and behave like a hyperlink, either with
    FollowHyperlink and adding the mailto prefix, or more simply with
    SendObject.

    Tony Toews has a bunch of other information on email from Access:
    http://www.granite.ab.ca/access/email.htm

    --
    Allen Browne - Microsoft MVP. Perth, Western Australia.
    Tips for Access users - http://allenbrowne.com/tips.html
    Reply to group, rather than allenbrowne at mvps dot org.

    "IanL" <IanL@discussions.microsoft.com> wrote in message
    news:725D8225-566A-4E2E-B8D1-BEA6E639E954@microsoft.com...
    >I have a textbox on a form that is linked to a hyperlink field.
    >
    > The field is used to input email addresses. However the hyperlinks don't
    > work because access prefixes them with http:/ (instead of mailto:).
    >
    > I can not find anywhere in the field or the text box to set this property.
    > So that access knows they are email addresses.
    >
    > Please Help!
     
  4. IanL

    IanL
    Expand Collapse
    Guest

    Thanks for your response Allen. This is useful although I find it hard to
    believe there is not a more direct way to do this. Email addresses are a
    pretty common use of hyperlinks! In fact I am amazed that access can't
    reconise the difference between an email address and a web address
    automatically.

    The manual approach is definately unworkable. The database will have several
    thousand entries, posted by many different users who won't all have the
    skills to edit this manually.

    If all else fails I will try the SendObject or FollowHyperlink methods...
    but I hope I can find a simpler way to fix this.

    Regards,

    Ian

    "Allen Browne" wrote:

    > You can right-click the address, and manually fix it by changing the
    > hyperlink part so it has the "mailto:" prefix.
    >
    > Realistically, that proves to be a very inefficient approach. I much prefer
    > to use a Text field, which avoids the problem and also saves users getting
    > confused between whether they changed the display address or the actual
    > address or both.
    >
    > You can still make it look and behave like a hyperlink, either with
    > FollowHyperlink and adding the mailto prefix, or more simply with
    > SendObject.
    >
    > Tony Toews has a bunch of other information on email from Access:
    > http://www.granite.ab.ca/access/email.htm
    >
    > --
    > Allen Browne - Microsoft MVP. Perth, Western Australia.
    > Tips for Access users - http://allenbrowne.com/tips.html
    > Reply to group, rather than allenbrowne at mvps dot org.
    >
    > "IanL" <IanL@discussions.microsoft.com> wrote in message
    > news:725D8225-566A-4E2E-B8D1-BEA6E639E954@microsoft.com...
    > >I have a textbox on a form that is linked to a hyperlink field.
    > >
    > > The field is used to input email addresses. However the hyperlinks don't
    > > work because access prefixes them with http:/ (instead of mailto:).
    > >
    > > I can not find anywhere in the field or the text box to set this property.
    > > So that access knows they are email addresses.
    > >
    > > Please Help!

    >
    >
    >
     

Share This Page