how to make this report?

[ariansman]

I have made a table which contains the data from some companies, such as company name, phone number and address, website, etc. I have also made a report over this table.


How can I make this report, so that if I click on the box that has the company website, it automatically open an explorer with that company website in the address bar?

[pbaldy]

Check out FollowHyperlink. Note the report can only be opened in Report view for this to work, not Preview.

[ariansman]

thank you,
i reviewed https://msdn.microsoft.com/en-us/lib.../ff822080.aspx. but i could not figure if i open the box properties in the form/report and then, on click, then what i should write there. can anybody advise?

[June7]

Code in the Click event of a textbox or a button on the report.

Instead of popup input box, reference field that has the company URL:

Sub btnWeb_Click()
Application.FollowHyperlink Me.fieldname, , True
End Sub

If the URL is saved into a Hyperlink type field, don't need any code.