Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Updating Hyperlink Field Using A Query

Status
Not open for further replies.

sroche

IS-IT--Management
Jul 6, 2001
4
US
I am trying to update a Hyperlink Field using an append query. When I update the table that contains the hyperlink field, only the Display text is populated. The actual hyper link is left blank. Any ideas would be greatly appreciated.
 
Hi sroche,

I think you need to put the hash sign in front of the text you are updating to, like:
Code:
"#[URL unfurl="true"]http://www.wpower.fsbusiness.co.uk/"[/URL]
[code][/color]
would display as:
[COLOR=blue]
[URL unfurl="true"]http://www.wpower.fsbusiness.co.uk/[/URL]
[/color]
in the table.

Bill
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top