<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=175&image=1&table=forumtopics' class='bbc_emoticon' alt=':(' />
Hi
I have 4 fields in an access database
field 1 - id number
field 2 - car name e.g. FORD (text field)
field 3 - car URL e.g. http://www.fordcars.com (text field)
field 4 - car name URL e.g. Ford (this is a hyperlink field which displays Ford but when you put your mouse over it you can see the URL to http://www.fordcars.com))
This works fine in ASP runner, you get field 4 to display OK
BUT
when I run an update query in access to create field 4 by combining fields 2 and 3 to create field 4 asp runner displays - Fordhttp://www.fordcars.com and links to http://Fordhttp://www.fordcars.com
When I edit the hyperlink field 4 manually in access it works OK but not when I have run an update query. The fields look the same in access when I look at them, I can't find any differences between the manual update and the query update
Any ideas!!!!!!!!!!!!!!!!
