I have a Hyperlink field in an Access 2000 database. After entering a web address, I click the right mouse and get to the Edit Hyperlink dialog. The dialog has the following options:

1. Type Text to display
2. Type the file or Web page name

I type the page to display and the web address. For instance:
Text to display = John Doe
Web Page = http://en.wikipedia.org/wiki/John_Doe

This worked perfectly in Access but when I connected it to my webpage, the hyperlink shows as http://en.wikipedia.org/wiki/John_Doe instead of John Doe. How can I make it to display only John Doe instead of the full URL. I use Frontpage 2000 and connected to the database via the Database Result Wizard.

P.S: My ASP webpage recognises the hyperlink and it works when clicked. I just want to display the name and not the full URL.

Thanks for your assistance.

RESOLVED.

I have finally figured out how to solve this problem. Just like TexasWebDevelopers (in another forum) suggested, I created a text field in additon to the hyperlink field. I did not touch the query below. I left it as it is.

SELECT * FROM MyQryCategoryName WHERE (CategoryID = ::CategoryID::) ORDER BY LastName ASC

But in Frontpage, I right clicked on the text field and clicked "Hyperlink Properties", then "Parameters" then "Insert Field Value" and then selected the Hyperlink/URL field itself. That's it. When I uploaded the file, the URL for the text field appear as John Doe, instead of www.JohnDoe.com. When you click on John Doe, it still takes you to www.JohnDoe.com which is what I want.