Limit hyperlinks to a database results field to the populated

[Guest]

Hi,

I have created a database results page where the Title field is also
hyperlinked to a db field (called Link) holding a new page to open. However,
all Titles fields in the database results show as hyperlinks. Is there a way
to restrict this to all those fields that the "Link" field in the database is
populated?

Thanks
Mario

 

[Guest]

Yes, in a custom query, define a calculated field similar to this:

SELECT IIF([Link]='', [Title], '<a href="'&[Link]&'">'&[Title]&'</a>') as
LinkTitle, ...

and then report the LinkTitle field. After the DRW finishes, right-click the
LinkTitle column value component (i.e. <<LinkTitle>>), choose Database Column
Value Properties, and select Column Value Contains HTML.

Jim Buyens
Microsoft FrontPage 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)
|/---------------------------------------------------
*----------------------------------------------------