Hyperlinkpart

[Lambi000]

What is the syntax for hyperlinkpart in a query? I already have the address
in the linked field, but I need to change the display text only without
overwriting the underlying link.

Every record has a different hyperlink so I need a method to ignore that
while updating the text. I tried an update using HyperlinkPart("Click
Here",1); I got "Click Here" in the field but the underlying address was gone.

 

[MGFoster]

What is the syntax for hyperlinkpart in a query? I already have the address
in the linked field, but I need to change the display text only without
overwriting the underlying link.

Every record has a different hyperlink so I need a method to ignore that
while updating the text. I tried an update using HyperlinkPart("Click
Here",1); I got "Click Here" in the field but the underlying address was gone.

The source column in the source table must be a Hyperlink Data Type for
the query to show the hyperlink format (blue underline).