unbound texbox hyperlink

P

Phil

Hi, thanks in advance for anyone who can help.

I have an unbound textbox that gets information from a combobox e.g.

=[combo18].[column](4)

this getting information that is stored in hyperlink format but it displays
as:-

#http://www.compton-hospice.org.uk/#

I cannot change the format of the textbox to hyperlink how can I get it to
display correctly

thanks

Phil
 
6

'69 Camaro

Hi, Phil.
I cannot change the format of the textbox to hyperlink how can I get it to
display correctly
Click to expand...

An unbound text box cannot hold a Hyperlink object. Either change the text
box to a bound text box which is bound to a Hyperlink column, or else change
the text box to an unattached label.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.
 
P

Phil

H Gunny

you have helped more than you think, after your reply I searched for labels
and hyperlinks and came up with one of your replies from 2005 I used the
following code

Me!Label89.HyperlinkAddress = _
Application.HyperlinkPart(DLookup("Website", "tblProvider", _
"ProviderID = " & Me!Combo18.Column(0)), acAddress)
Me!Label89.HyperlinkSubAddress = _
Application.HyperlinkPart(DLookup("Website", "tblProvider", _
"ProviderID = " & Me!Combo18.Column(0)), acSubAddress)
Me!Label89.Caption = _
Application.HyperlinkPart(DLookup("Website", "tblProvider", _
"ProviderID = " & Me!Combo18.Column(0)), acDisplayText)

which worked perfectly, thanks again

Phil
 
6

'69 Camaro

you have helped more than you think, after your reply I searched for
labels
and hyperlinks and came up with one of your replies from 2005 I used the
following code
Click to expand...

You're welcome! Glad it worked so well for you!

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.
 
Top