May 7, 2008 at 9:34 am
On migrating an access db to SQL-Server 2005, the web addresses stored in Access as hyperlink data type's converted across to nvarchar(max) datatypes in SQL Server 2005 and are stored as for example http://www.tclarke.co.uk. The user insists on keeping Access as the user front end, however the web address now stored in the linked SQL Server table is not viewed as a hyperlink by the Access front end and so clicking the web address no longer hyperlinks to the web site.
Can anyone help with this?
Many thanks
🙂
Neil Crabtree
May 7, 2008 at 10:43 am
I don't think you can change that in the Tables view in access. However, in text boxes on both Forms and Reports you can set the IsHyperlink property to display the data as a hyperlink.
May 7, 2008 at 12:17 pm
You can't set them that way in the data source in SQL, but you can either set the IsHyperlink property of the display, as mentioned above, or set an OnClick event that follows the hyperlink.
I've had some trouble getting the IsHyperlink property to work correctly, but I've had great success with setting the OnClick or OnDoubleClick event. Your milleage may vary. 🙂
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
May 8, 2008 at 3:40 am
Thanks for your responses, will try IsHyperlink property otherwise write code to follow hyperlink
May 9, 2008 at 10:15 am
Thanks for your advice re URL. The IsHyperlink property in the form worked immediately, not sure how I overlooked this!! With regard to you have had difficulty with IsHyperlink Property I note that the form of the web address has to be [display name]#http://www.xxxxx.xxx#, display name being optional. So hope that helps also.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply