Hyperlink Format Displayed in Database Results / FP2003 asp.webpag

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Dear FP Community,

Figured out how to show a hyperlink in my database results field but it
shows the full hyperlink string - is there a way to display as for example
just a "click here" text so it's shorter.

The weird thing is my in my actual database table I have used the design
option to make the column "hyperlink" - typed the text "Click Here" and then
linked to the full http string. But in my FP database results it shows the
full string.

Can you help please,

Brian
 
Hi Brian,
You can't use Access hyperlink fields on the web. Store just the url
(http://site.com/page.htm) as a text field in Access then pull out a link,
eg

SELECT '<a href="' + UrlField + '">click here</a>' AS YourLink
FROM
Table
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hyperlinks in Access Database Results Displayed in my *.asp webpag 1
Database Results with hyperlink fields 2
access hyperlink 1
Hyperlink display using access database with FP2003 5
data base hyperlinks 18
Hyperlinks from Database Results 27
Drop down add hyperlink box 10
Hyperlinks not displaying 4

Back
Top