Introduction to Hyperlink fields

        5 votes: ***       14,866 views      0 comments
by Allen Browne, 20 April 2005    (Access 97+)

Microsoft Access Tips for Casual Users

Provided by Allen Browne, allen@allenbrowne.com


Introduction to Hyperlink fields

Access 97 introduced this field type for storing links to files on:

  • your computer (a file name);
  • a network (a UNC name);
  • the internet (a URL address).

A hyperlink entry contains three parts separated by pound signs (#). The template is:

    display text # file name # any reference within the file

Use the Insert menu to add a hyperlink entry, and Access takes care of the three parts. Only the "display text" part of the field is shown, and clicking on the field executes the link.

So how can you view its full contents or edit the field?

  1. Click the attached label, to move the cursor into the hyperlink field. (If the field has no label, use the Tab key.)
  2. Press F2 to edit the field. All three parts of the hyperlink are displayed for editing.

Some examples may help show how this works:

Hyperlink Contents Displays When Clicked
My photo#c:\pix\photo.bmp# My photo Loads picture into MS Paint.
SS data#ss.xls#Sheet 1!G9 SS data Loads spreadsheet into Excel, selecting cell G9.
Do labels#\\jane\pub\label.doc# Do labels Loads the network document into WinWord.
Edit Clients##Clients Edit Clients Opens Clients form in current database (no file specified).
Sales info##Query Sales Sales info Runs the Sales query in the current database.*
IBM#http://www.ibm.com# IBM Loads your web browser and opens the URL.
#www.canon.com# www.canon.com Loads your web browser, assuming prefix of "http://".
  • * The word "Query" in this hyperlink is optional. However, if the current database had a form named Sales, Access would open the form in preference to the query.

Home Index of tips Top

Rate this article:   Your rating: Poor Your rating: Not so good Your rating: Average Your rating: Good Your rating: Excellent


This is a cached tutorial, reproduced with permission.

Have your say - comment on this article.

What did you think of 'Introduction to Hyperlink fields'?

No comments yet.

Why not be the first to comment on this article?!

Have your say...

Name
E-mail (e-mail address will be kept private)
Comments
Verify Code
Verification Code


It may take 30 seconds after clicking submit - please be patient to avoid duplicate submissions.  

All comments must be approved before being displayed on this web page.  This process may take up to 24 hours.