How can I allow hyperlinks to be 'clickable' in a report?

S

shanem

I'm using Access 2000 - I'm running a query on a table that contains one
field of hyperlinks and using the report to output the findings. However,
the Hyperlinks are not 'clickable'. Can this be remedied to allow me use the
hyperlinks when viewing a report?
 
R

Rick B

A report, by nature, is a printed document. You can't interact with it. It
is a printed document on paper. All you are seeing is a picture of it.

Build a form if you want to be able to interact with the objects.

Rick B
 
S

shanem

This may well be partially true in the sense that a tradition report was a
'piece of paper' however, many reports (word docs, pdf's etc) that are
printable have hyperlinks that are 'Clickable' when viewed on the screen. I
know that Access can output the report to HTML format where the hyperlinks
are 'clickable' however, the formatting of the report is lost.
A form can provide interactivness, but it is the presentation of a report
which provides the 'user-friendlyness'!!
 
R

Rick B

A Word document CAN contain links (this is true), but a print preview of
that Word document cannot.

In my opinion (and I could be wrong), an Access report is nothing more than
a print preview.

My recommendation is to make a form if you want to have hyperlinks. You can
make it look very very similar to your report, but it allows you to place
the types of controls you mention on it.

Good Luck,

Rick B
 
B

Brendan Reynolds

None of the Access report controls respond to click events.

This is what Data Access Pages were supposed to do - to combine some of the
features of reports with the interactivity of forms. They don't seem to have
taken off, though - few people seem to use them, and Microsoft haven't done
much with them in the last two releases of Access. For these reasons, I
don't use them myself, and don't feel I can recommend them. I'm not
convinced that they have a long-term future. But the option is there if you
want to check it out.

Otherwise, I agree with Rick, that if you want interactivity you need to use
forms.
 
S

shanem

Thanks guys, I've started down the route of the form. I did attempt to use
the Data Access Pages but as you've pointed out they don't seem to be user
friendly
 
B

Brendan Reynolds

I don't wish to be picky, but in the interest of accuracy (these posts are
archived after all) can I just point out that I never actually expressed any
opinion about whether Data Access Pages were user friendly or not.
 
Top