Links in Access report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi
When I make a report with links within the data - the links destination-URL
are show right after the data from the database...

Fx the data that the report should show: "Michael 8 goals." (and by clicking
on "Michael" you should be directed to Michaels site...)
The report actually shows "Michael#Michaels site# 8 goals..."

How can I avoid the #Michael site# part????
 
IMHO, there is a fundamental concept problem with having a hyperlink on a
report. To me, reports should be printed to a printer.

It may be that the report rendering application doesn't understand what to
do with a hyperlink.
 
Hi,


Sounds like a formatting problem. # is there used to delimit the three parts
that make a "hyperlink": the display, the address and the sub-address.



? HyperlinkPart("aaaa#bbbb#ccccc", acDisplayText)
aaaa



Hoping it may help,
Vanderghast, Access MVP
 
Hi...
Well it is the same problem even if its not a report...
The table as well shows the # followed by the link-adress...

Jørgen Lauridsen

"[MVP] S.Clark" skrev:
IMHO, there is a fundamental concept problem with having a hyperlink on a
report. To me, reports should be printed to a printer.

It may be that the report rendering application doesn't understand what to
do with a hyperlink.
Click to expand...
 
Hi,
When I change a coloum to hypertext the problem apears... Every post is
changed to the #-thing...

I don't get it... ;-)

Jørgen

"Michel Walsh" skrev:
Hi,


Sounds like a formatting problem. # is there used to delimit the three parts
that make a "hyperlink": the display, the address and the sub-address.



? HyperlinkPart("aaaa#bbbb#ccccc", acDisplayText)
aaaa



Hoping it may help,
Vanderghast, Access MVP
Click to expand...
 
Hi,


Can you use the VBA function HyperlinkPart( ), to display the portion
you wish to display (under your full control) ?


Hoping it may help,
Vanderghast, Access MVP


Jørgen Lauridsen said:
Hi,
When I change a coloum to hypertext the problem apears... Every post is
changed to the #-thing...

I don't get it... ;-)

Jørgen

"Michel Walsh" skrev:
Click to expand...
 
Hi Michael,

I'm using the danish version of Access, so I dont know what you mean by VBA
function... Can you describe it futher... Step by step for example...?

Jørgen

"Michel Walsh" skrev:
 
Hi,


Have a form, with two text control (text0 and text2). Cut and paste the code
to the form

'========================
Option Compare Database
Option Explicit

Private Sub Form_Current()

Dim MyString As String

MyString = "Hello world#www.microsoft.com#"

Me.Text0 = HyperlinkPart(MyString, acDisplayText)
Me.Text2 = HyperlinkPart(MyString, acFullAddress)

End Sub
'========================


The hyperlink, in MyString, is then properly split into its components. It
should work for a string stored in a field as well as here, stored into a
local variable.




Hoping it may help,
Vanderghast, Access MVP
 
Hi Michel...

Sorry to tell you, but I cant get it to work...

Is it possible for you to make me a an example and then email me it...?
Then I could have a chance to see would you would handle the problem...

Jørgen

"Michel Walsh" skrev:
 
Hi,


The example won't be much more than what I posted... but since you ask
for it... :-) discussions.microsoft.com is, unfortunately, an unknown ISP.



Vanderghast, Access MVP
 
Hi, Michel

Please send an example to (e-mail address removed) - I'll close this email
account right after I have recieved your email to avoid junkmail...

Thanks a lot for helping me with this problem...

Jørgen



"Michel Walsh" skrev:
 
Back
Top