Create a column to store hyperlinks

In a Microsoft Access project (.adp) connected to a Microsoft SQL Server 2000 database, you can create a character string field that contains a hyperlink .
  1. In the Database window, click Tables under Objects, click the table you want to open, and then click Design on the Database window toolbar.
  2. In the first blank row, click in the Column Name column and type a unique name for the field.
  3. In the Data Type column, select char, nchar, nvarchar, or varchar.
  4. In the Length column, set an appropriate value (in number of characters) for the hyperlink addresses that you'll store.
  5. In the column properties, under the Columns tab, scroll down to the Hyperlink property, and set the value to Yes.
  6. Click Save   to save the table definition.

Note   If you don't want to change the table definition, you can still create a hyperlink on a form or report control containing a character string data type field by setting the Is Hyperlink property to Yes.