Hyperlink Part

[Martin]

Hello,

I have a query that builds a hyperlink from various other fields which work
fine. This query is then used on a form and for the hyperlink field I use
the OnClick Event and FollowHyperlink which also works fine.

However I want to display some text such as "Click here" instead of the
hyperlink, does anyone know how to do this?

Here is the field that builds up the hyperink:

Hyperlink: HyperlinkPart("http://MyAddress" & [FieldName])

I was expecting it to be something like:

Hyperlink: HyperlinkPart("http://MyAddress" & [FieldName], "Click here") but
that returns an error.

Any help woudl be appreciated.

Martin

 

[Stefan Hoffmann]

hi Martin,

Hyperlink: HyperlinkPart("http://MyAddress"& [FieldName], "Click here") but
that returns an error.

hmm, 'Click here' does not carry any meaningful information.

Any help woudl be appreciated.

Use the Object Browser (F2) in the VBA IDE:

Function HyperlinkPart(Hyperlink, [Part As AcHyperlinkPart =
acDisplayedValue]) As String
Element of Access.Application

E.g.

Hyperlink:
HyperlinkPart("http://MyAddress" & [FieldName], 2) &
HyperlinkPart("Click here", 1)

mfG
--> stefan <--