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
ES-ComponentsAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Mark EdwardsChief Technology OfficerCommented:
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 FyeOwner, Developing Solutions LLCCommented:
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.
PatHartmanCommented:
I also don't use the hyperlink data type that that is mostly because SQL Server does not support it.  To simulate one, you can use two text fields.  One hidden, one for display.  Clicking on the display control, runs the FollowHyperlink method on the hidden field.  Of course to edit the hyperlink, both fields need to be visible.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ES-ComponentsAuthor Commented:
This solution worked for me.

Thanks...
Rick
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.