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.
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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.