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 8 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 (3) |
Tidak ada komentar:
Posting Komentar