html property vs html field data type

[thersitz]

Hi,

I have a field in a table set to the hyperlink data type. The data in the
table contains actual url's in each field.

I have a form that uses the table as its recordsource. I have a text box
control on the form mapped to the url field. I set the textBox's isHyperlink
property to yes -- but when I have the form open I cannot click on the text
box to jump to the web page. So this must not be doable.

Can anyone point me to a resource or make suggestions on how best to use
that field and text box to follow the stored hyperlink.

thanks

 

[thersitz]

I ciphered my grief. It seems to me that if you have converted a database
from an earlier ver. to a 2003 db -- and then reuse some forms, binding them
to different tables and the controls to the new fields in those table --
those pre-converted controls don't seem to recognize the hyperlink data
type. To fix my problem, I deleted the textBox I had bound to my hyperlink
field and which was from the original db, added a new text box and bound
it -- and now it works.