Overlay text over a Hyperlink

[GrahamUK33]

Can I overlay text from Field1 over a hyperlink that is in Field2 from a table/query, and then display within a text box on a report?

 

[isladogs]

Here's an alternative suggestion.
On your form textbox (or you can use a label) add a click or double click event with code

Application.FollowHyperlink "hyperlink location"

 

[GrahamUK33]

I have two fields on a form, text and hyperlink which are saved in a table. When I call up a report I am looking at overlaying the text (field1) over the hyperlink (field2).

What I have found so far is to change the properties of the field on the report to:

• Forecolour: Hyperlink Color
• Is Hyperlink: Yes
• Display as Hyperlink: Screen Only
• Hyperlink Target: [qryQuery!Field2]

What the above has done is changed the text with in the text box to look like a hyperlink, but nothing happens when it is clicked or double clicked on.

 

[arnelgp]

As suggested by ridders, use that command on the double click event of field1

Private field1_doubleclick()
Followhyperlink spli(me.field2, "#")(1)
End sub

 

[GrahamUK33]

I have tried the code above, which gives a Compile Error: Sub or Function not defined.

 

[arnelgp]

Go to ur form in design view. Click on field1. On its property->event select double click. Add the code.
You also need to add field2 on the form. Set uts visible property to No if you dont want to show it.

 

[GrahamUK33]

The textbox is on a ‘Report’, once double clicked it needs to open the URL.

 

[arnelgp]

Same steps with report

 

[GrahamUK33]

I that a character was missing from the code
Followhyperlink spli(me.field2, "#")(1)

should be:
Followhyperlink split(me.field2, "#")(1)

This solution now works, thanks.

 

[arnelgp]

Ur welcome.