Hyperlink in a textbox

L

LenP

Scenario:

I have a form with a combo box and two text boxes. The combo box data comes
from a lookup query and the results of the query populate the two text boxes.
The data supplied from teh query to the second text box is a hyperlink,
embedded in the table used as a source for the lookup query.
From the raw query if I click on a hyperlink it works fine, however when I
click on the textbox control on the form, nothing happens. In fact, this is
what is displayed in the control on the form:

..ac – Ascension Island#http://www.iana.org/root-whois/ac.htm#

where it should only show:

..ac – Ascension Island

Does anyone have any ideas?

TIA,
LenP
 
Top