Hyperlink on a report

[Raj]

Dear ALL,

Is it possible to have a hyperlink on a report page? I couldn't find any way

Any help highly appreciated

Thanks.
Raj.

 

[Rick Brandt]

Dear ALL,

Is it possible to have a hyperlink on a report page? I couldn't find
any way
Any help highly appreciated

Thanks.
Raj.

If you mean something you can click on when previewing the report and have
the link "do something" then no. An Access report print preview is just an
image. You cannot interact with it.

 

[Guest]

You could publish the report to Word - links will work in the resulting .rtf
file.

 

[Guest]

As a follow-up to this question, when I export a report to .rtf, the
hyperlink in the .rtf file does not display correctly. For instance, it may
display as #www.aep.com#www.aep.com or http://www.aep.com##www.aep.com

Is there a standarized format for entering URL's in a database form (the
table field is a hyperlink type, and the property format for the report field
is set YES to grow and YES to hyperlink. This is Access 2003.

Thanks!

 

[SA]

What you see displayed is how Access stores hyperlink information in
A2000-A2003 in the field itself. When exporting data, its not formatted at
all, rather its exported in a raw form, there's no way to work around this
other than to use a text field rather than a hyperlink.

 

[Guest]

How is do you publish the report to word each time that report opens. What
VBA would you use? I can export it through File>Export, is there an easy way
of doing this?

 

[SA]

You can also use DoCmd.OutputTo in VBA to export your report to RTF.

On the hyperlink issue, Access report's aren't active documents, they are
graphic representations of the data, so active hyperlinks are out. If you
want to create a document from your report that maintains the look and feel
of the report and has active hyperlinks then you need to print it to a PDF
file. You can use printer drivers like Win2PDF and PDF X-Change to output
this with active hyperlinks. If you want to automate the procuess you can
look at our PDF and Mail Library for Access

 

[Guest]

Just figured it out last night, thank you for the response though. It words
just as I need. I don't care about formatting.