Hyperlink Inactive in text box

[Luck]

Thanks for taking the time..

I have created a Form called "Directories" with a subform named "Files Query
subform". All fields are bound to SQL statements.

There are 2 controls in the subform. One is a combo box named "Atlas Index"
and the second is a text box named "Directory" to accept hyperlink data.
A Hyperlink is bound to a Query Field named "Directory" within the text box
on "Files Query subform".

The Control Source of the text box is =[Atlas Index].Column(5). Although the
hyperlink functions properly in the Query, it is inactive within the text box
and is shown within #------------#:

The Atlas Index].Column(5) refers to 6th item in the datasheet and is
correctly bound. If the same Control Sourrce is changed to the field
"Directory" it activates the hyperlink.

Can anyone please help?

 

[John Nurick]

Hi Luck,

I think that what's happening is this:

When a textbox is bound to a hyperlink field it's "aware" of the fact
that it's a hyperlink and responds accordingly. But a column in a
multi-column combobox is just a string of characters and there's nothing
to tell the textbox that it's a hyperlink.

One way round the problem - probably the best - would be to revise the
design of your subform and/or form so the textbox could be bound
directly to the hyperlink field.

Another would be to change things so the textbox and underlying field
contain just the address (without the #display text#address#subaddress
structure of the text in a hyperlink field), and use code in its Click()
event to activate the hyperlink, something like

Application.FollowHyperlink Me.ActiveControl.Value

Thanks for taking the time..

I have created a Form called "Directories" with a subform named "Files Query
subform". All fields are bound to SQL statements.

There are 2 controls in the subform. One is a combo box named "Atlas Index"
and the second is a text box named "Directory" to accept hyperlink data.
A Hyperlink is bound to a Query Field named "Directory" within the text box
on "Files Query subform".

The Control Source of the text box is =[Atlas Index].Column(5). Although the
hyperlink functions properly in the Query, it is inactive within the text box
and is shown within #------------#:

The Atlas Index].Column(5) refers to 6th item in the datasheet and is
correctly bound. If the same Control Sourrce is changed to the field
"Directory" it activates the hyperlink.

Can anyone please help?