access hyperlink

[Guest]

I'm using Front page to get results from an access database search.
In the access table I added the hyperlink and the results page does get the
right hyperlink.

My problem is it displays the full hyperlink URL when I just want it to
display text. In the edit hyperlink I put the text I want into the display
line - but it still gives me the URL

How do I show just the display text while still having the underlying link.

Thank-you

 

[Guest]

You have to store the hyperlink text and the corresponding URL in separate
text fields, and use a custom query to assemble the HTML you want. Here's an
example"

select '<a href="'' & [resorturl] & ''">' & [resortname] & '</a>' as
resortlink, ...

In the finished database results region, you'll also have to right-click the
column value component, choose Column Value Properties, and select Column
Value Contains HTML.

Jim Buyens
Microsoft MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Windows SharePoint Services Inside Out
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------