Hyperlink on a report

R

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.
 
M

Mark Andrews

If you create a pdf file out of a report certain pdf drivers will change
text that looks like a hyperlink into an actual hyperlink. win2pdf being
one that does that.

Not sure if that helps you out or not,
Mark
 
W

Wendy Farkas

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

TblackOGF

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!
 
S

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.
 
A

Aviator

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?
 
S

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
 
A

Aviator

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