Hi.
When a generate the
report is it possible to make the links active in the report so that the user
can access the site by clicking on the link.
No. The Hyperlink property isn't carried through to the report. However,
the query you used as a Record Source for this report can be exported to an
Excel spreadsheet and the Hyperlinks will carry through.
To do so, select the query's name in the Database Window or open the query
in Datasheet View or SQL View and then select the Tools -> Office Links ->
Analyze it with Microsoft Excel menu, and a new spreadsheet file will be
created for you.
HTH.
Gunny
See
http://www.QBuilt.com for all your database needs.
See
http://www.Access.QBuilt.com for Microsoft Access tips.
(Please remove ZERO_SPAM from my reply E-mail address so that a message will
be forwarded to me.)
- - -
If my answer has helped you, please sign in and answer yes to the question
"Did this post answer your question?" at the bottom of the message, which
adds your question and the answers to the database of answers. Remember that
questions answered the quickest are often from those who have a history of
rewarding the contributors who have taken the time to answer questions
correctly.
