Hyperlinks in an Access report

[Guest]

I have a report in Access (2002) which has some of the labels setup as
hyperlinks. Naturally, these links don't work in Preview mode, but when I
export the report to an RTF document, the links DO work. Well, sort-of. If a
specified HTML page is divided into sections (normally ref'd by the "#LABEL"
code), the hyperlink DOES NOT go to the section. rather, it just goes to the
top of the document.

However, if I RIGHT CLICK (in Word) and select OPEN HYPERLINK, the correct
section *IS* pulled up. This happens regardless of whether or not I use the
"HYPERLINK SUBADDRESS" field in Proerties for the control.

Can someone point me in the right direction to make this work right?

Thanks!

 

[Arvin Meyer [MVP]]

It is working right in Word. Word recognizes the profile of the hyperlink
format and internally resolves it to open that hyperlink (if you hold the
control key down and left click or right click and choose Open hyperlink).
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Guest]

That's just it - in Word, when I hold CTRL and LEFT CLICK, I only get the TOP
of the page, but if I RIGHT CLICK and select OPEN HYPERLINK, I get taken to
the correct section. I'm at a loss as to why this is happening (Word 2002).

 

[Arvin Meyer [MVP]]

I suspect that left-clicking does not understand the #label and just follows
the hyperlink portion. I do know that the mailto protocol also requires the
# on either side of the email address, and the conversion may get this
confused. You may get a better answer in a Word newsgroup.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access