Database Results with hyperlink fields

[Guest]

I'm trying to use Access 2003 for my Database Results database. I created a
table field that contains the "hyperlink" format. The "text to display" is
different from the URL in the hyperlink. When I do a practice run, the
Database Results displays the URL and not the actual hyperlink I typed in the
table field. I would like to have the hyperlink that I typed in the field to
display on my webpage with the URL behind it. I don't want the actual URL to
display on my webpage. I can get to the "Database Column Value Properties"
by right-clicking and choosing "Display as Hyperlink". After that, I don't
have a clue where to go.

Thanks.

 

[Andrew Murray]

You can put a line of html as the field value and also click the "Show as
HTML" or whatever that other option is.
so the "actual" value of your field would be "<a
href="http://www.yoursite.com/whatever.html">Click Here</a>

and then in the results area, click the option "Allow HTML" or "Show as
HTML" so that the "Click here" shows in the results page when you view the
page online, and it links to whatever page you've specified. If it's a page
within your web, then you can use the relative URL, but outside your web,
use an Absolute URL.

There's a warning about using HTML in database fields, but unless someone
serious hacks your db and does something dramatically bad, I'm sure it's OK.
I have fields that I allow HTML in, but Idon't have any forms online that
submits the data, I do all the editing of the db offline in Access itself
and republish the mdb file each time, I find that's easier.

 

[Bob Lehmann]

The hyperlink datatype is proprietary to Access and won't diplay as a link
on a web page.

http://databases.aspfaq.com/databas...memo-text-hyperlink-and-currency-columns.html

Scroll down to ' Hyperlink, Currency, MONEY ' for an explanation.

Bob Lehmann