Hyperlink Display

[kitty77]

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]

Typo... And does anyone know why this happens?

 

[theDBguy]

I think that's called the file protocol.

file Protocol

docs.microsoft.com

 

[strive4peace]

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.

 

[bastanu]

You might also want to read about the HyperlinkPart method:

Application.HyperlinkPart method (Access)

Office VBA reference topic

docs.microsoft.com

Cheers,