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

 

you're welcome, Kevin ~ happy to help
~ crystal

On 3/13/2019 6:28 PM, qingqinga  [MS_Access_Professionals] wrote:

Dear Crystal,

I got it. Thanks a lot.

Best Regards,

Kevin

发自 WPS邮箱客戶端

在 "crystal 8 strive4peace [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>，2019年3月14日 04:06写道：

 

to answer your question about code:

the HyperlinkAddress property has the main link

the HyperlinkSubAddress property is the location within the document/page

~crystal

On 3/13/2019 2:13 PM, crystal strive4peace [MS_Access_Professionals]
wrote:
> 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>
> ------------------------------------
>
>
> ------------------------------------
>
> 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 (5)

---

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

.

__,_._,___