Understanding Access 97's Hyperlink Field Data Type

Access 97 adds a new member, Hyperlink, to its repertoire of field data types. Hyperlink isn't a Jet 3.5 data type, because Jet 3.5 stores Access Hyperlink values in Memo fields. Access 97's Hyperlink data type simply interprets the value of the Memo field as a hyperlink and formats the display accordingly.

A Hyperlink field value may consist of the following three components:

  • Display text, an optional descriptive name for the hyperlink that appears as emphasized text, usually underlined and having a distinctive color.

  • Address, a required reference to the location of a related document. The reference can be an Internet URL for World Wide Web and FTP (File Transfer Protocol) sites, a relative ...

Get Special Edition Using Access 97, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.