Front Page and Database Results Regions

[Adrian Neale]

I am trying to produce a database results region in Front
Page 2002, except I want one of the fields to be a
Hyperlink, and to show me only the link text in the
database field rather than the entire URL. At the
minute, my Access Database field shows me, as an
example, "Link", which is then set in access as a
hyperlink to http://mysite.com/images/link.jpg, but when
I publish on my web server and I preview it in IE, it
shows the whole URL in the results field, i.e. instead of
showing "Link", it
shows "http://mysite.com/images/link.jpg"

 

[Kathleen Anderson [MVP- FP]]

So the value of the field in your database is: <a href="http://mysite.com/images/link.jpg">Link</a> The field should be defined as Text (or Memo, depending on the length) in your database. Then, in your results page, in Normal View, right click on the field, choose Database Column Value Properties, and put a checkmark in the box that says "Column value contains HTML."

--

~ Kathleen Anderson
Microsoft FrontPage MVP
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/

 

[Kathleen Anderson [MVP- FP]]

My newsreader appears to be mangling the link - suffice it to say, the word Link should NOT be part of the url.

--

~ Kathleen Anderson
Microsoft FrontPage MVP
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/