Hyperlink Display (1 Viewer)

kitty77

Registered User.
Local time
Today, 11:11
Joined
May 27, 2019
Messages
693
Does anyone know why in my table field1 (which is a hyperlink) shows file:///A:\Test\12345.pdf
When you select edit hyperlink, you see Text to display: A:\Test\12345.pdf and Address: A:\Test\12345.pdf

How can I change the link in the table to look like the other two? And you does this happen?
 

kitty77

Registered User.
Local time
Today, 11:11
Joined
May 27, 2019
Messages
693
Typo... And does anyone know why this happens?
 

theDBguy

I’m here to help
Staff member
Local time
Today, 08:11
Joined
Oct 29, 2018
Messages
21,359
I think that's called the file protocol.

 

strive4peace

AWF VIP
Local time
Today, 10:11
Joined
Apr 3, 2020
Messages
1,003
hi @kitty77

a hyperlink has different parts

AcHyperlinkPart enumeration​

https://docs.microsoft.com/en-us/office/vba/api/access.achyperlinkpart

'0 acDisplayedValue The underlined text displayed in a hyperlink.
'1 acDisplayText The displaytext part of a Hyperlink field.
'2 acAddress The address part of a Hyperlink field.
'3 acSubAddress The subaddress part of a Hyperlink field.
'4 acScreenTip The tooltip part of a Hyperlink field.
'5 acFullAddress The address and subaddress parts of a Hyperlink field, delimited by a "#" character.
 

Users who are viewing this thread

Top Bottom