Hyperlinkpart

L

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.
 
M

MGFoster

Lambi000 said:
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.
Click to expand...

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