Re: [MS_AccessPros] How to remove the hash tag and text in between the hash tags

 

hi Kevin,

store as Short Text (or Long Text if you need more than 255 characters,
if you must!), not hyperlink.

Hyperlink fields can contains four parts separated by octothorpes (#), 
or pound signs, number signs, hash tags.

1. The first part of a hyperlink is the text to display.
2. The second part of a hyperlink is the actual address of the file.
3. The third part of a hyperlink can reference a named section within
the specified file,
4. and the fourth part is the screen tip.

(I prefer to store the actual address (and named section if specified)
of hyperlinks in short text fields and use application.FollowHyperlink)

have an awesome day,
crystal

free code you can use in your projects
https://msaccessgurus.com/code.htm

On 3/13/2019 4:56 AM, Kevin qingqinga [MS_Access_Professionals] wrote:
> Dear All,
>
> As we know, behind the hyperlink there are hash tags. My question is how
> to remove the hash tags and the texts in between with code? Thanks.
>
> Best Regards,
> Kevin
>
>
>
> ------------------------------------
> Posted by: Kevin <qingqinga@yahoo.com>
> ------------------------------------
>
>
> ------------------------------------
>
> Yahoo Groups Links
>
>
>

__._,_.___

---

Posted by: crystal 8 <strive4peace2008@yahoo.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (2)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

SPONSORED LINKS

.

__,_._,___