Code doesn't add hyperlink address

[zipaway]

I have the following code:

rstTable("Link").Value = "C:\Program\test.xlsx"

This updates my "link" field with the new hyperlink. The hyperlink address is missing though so you can't click the link.

What code would allow me to change the address part of the hyperlink field?

[ItsMe]

What is the Data Type of your field named, "Link"?

[zipaway]

What is the Data Type of your field named, "Link"?

the data type is a hyperlink.

[June7]

Hyperlink strings have a specific format. Review http://www.allenbrowne.com/casu-09.html

[zipaway]

Hyperlink strings have a specific format. Review http://www.allenbrowne.com/casu-09.html

Yes, I understand hyperlinks have 3 components. I can change the "text" of a hyperlink with code but not the actual "address".

How could I modify a hyperlink entry address with code? Any help would greatly be appreciated.

[June7]

Just include the # characters

rstTable("Link").Value = "#C:\Program\test.xlsx#"

Another link you might find of interest http://allenbrowne.com/func-GoHyperlink.html

[zipaway]

Just include the # characters

rstTable("Link").Value = "#C:\Program\test.xlsx#"

Another link you might find of interest http://allenbrowne.com/func-GoHyperlink.html

Thank you so much! This worked, and thanks for the additional resources.