Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2009
    Posts
    28

    Unanswered: hyperlinks and hashes (#)

    My query accesses a table with 2 hyperlink fields, and this works fine.
    However, if I add a union to my query, the hyperlinks show "#" symbols
    at the beginning & end.

    Can anyone advise how I can remove them ?

    Many thanks

  2. #2
    Join Date
    May 2009
    Posts
    258
    That's how they are stored, Just use the Replace function, i.e. Replace(field,'#','').

    Alternatively, Mid(field,2,Len(field)-2).

    Microsoft Access tips: Introduction to Hyperlink fields

    Regards,

    Ax

  3. #3
    Join Date
    Jul 2009
    Posts
    28

    hyperlinks and hashes (#)

    Thanks Ax.

    Your suggested syntax does indeed remove the hashes from the start & end, but what is then left is no longer a hyperlink.

    I can however set the "Is Hyperlink" Format Property setting within my Form to reset them as such.

    Many thanks.
    Ian

  4. #4
    Join Date
    May 2009
    Posts
    258
    Sounds good, glad you got everything sorted out.

  5. #5
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Quote Originally Posted by dmac25 View Post
    Thanks Ax.

    Your suggested syntax does indeed remove the hashes from the start & end, but what is then left is no longer a hyperlink.

    I can however set the "Is Hyperlink" Format Property setting within my Form to reset them as such.

    Many thanks.
    Ian
    For what it's worth, I'm a firm believer of storing only the string needed to generate the hyperlink and using formatting on the form/report (as you are doing now) to "linkify" the url. This saves all kinds of headaches should you need to work with this data outside of access in the future.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •