Front Page and Database Results Regions

  • Thread starter Thread starter Adrian Neale
  • Start date Start date
A

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"
 
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/
 
Back
Top