asked on

Why does the Access subform not display the hyperlink?

Why does the table (OTS-DiodePriceList12-3-18) with a field name of 'PDF' that was imported as a hyperlink field NOT display the
hyperlink in the OTS_DiodePriceList12318_subform?

I have to manually go to the table, right click the record under PDF, click edit hyperlink, then copy and paste the
'text To Display' field to the 'Address' field?

What did I do wrong in the import table process? I REALLY do not want to manually enter almost 1000 records.

Any help would be greatly appreciated. I have attached the Access database for review.

Thank you...
Rick
DiodePricing--2-.accdb

Mark Edwards

Simply put, the hyperlink data type is NOT recognized by Access as a hyperlink, but as a text when imported.
You'll need to import your data into an Access table that already has the data type for that field set to "Hyperlink" (look at your "PDF" field in your tables with the hyperlinks in design view.)

Dale Fye

Personally, I don't like the hyperlink datatype, and prefer to store the link as text. Then I use a button to the right of a textbox to launch the hyperlink.

But if you really want Access to recognize the hyperlink, you can probably copy your recordID and the Hyperlink field values to another (temp) table. Then modify the data type of the field you want to be a hyperlink in your table, and then re-import the data from the temp table back into the hyperlink field.

ASKER CERTIFIED SOLUTION

PatHartman

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ES-Components

ASKER

This solution worked for me.

Thanks...
Rick