create hyperlink & append table

[patti]

I am using several text functions to create a field which forms the text of a
hyperlink. This is for an append query.
When the records are appended to the table, the field shows as a hyperlink
but clicking on the hyperlink goes nowhere - it doesn't even launch browser.
If i copy the hyperlink (the whole field) & paste into address bar in ie
window, it takes me to proper webpage. if i edit the "cell" (i hit f2, i am
at the end of the link, i hit delete (and there is nothing to delete), then
hit enter), then click on the cell, i am taken to the webpage.

The table does have that field as hyperlink.

Thanks for the help.

 

[patti]

upon further investigation, i found the answer within these discussion
groups. Allen Browne is the man.

http://allenbrowne.com/casu-09.html