I've got this table that had email address and website fields as short text types. I have created two new hyperlink type fields and cut/pasted all the data from the old fields into the new hyperlink types. They show up fine in the form and the cursor changes from an arrow to a hand when hovered over them, so i know they are working, but when clicked nothing happens. I was expecting my email program to open in the case of the email fields and browser to open and go to web page when website field is clicked..but nothing. Anyone know why?
Hyperlink data types - not working
- Thread starter SGT68
- Start date
No doesnt work in table or form. Everything else in app works fine, vba etc
The FollowHyperlink method is not available from the macro onclick event drop down list... i think you can only use it in vba and then have to use it with arguments.
Re Forms: Firstly you have to use a hyperlink form control, which is in the Design part of the ribbon. That then presents you with an extensive dialog which gives you all sorts of options ...try it and see, but it does not, well i cant find an option that lets you follow the link that exists as the controls current value . The design of it only allows for permanent precoded urls that are referenced via this dialog, not ones that may be entered on a form and therefore liable to real time change..
So.. some clever vba using a hyperlink form control and the FollowHyperlink method could possibly achieve the result of going to whatever url or email address was the controls value, but probably by no other way.
Given all this i we can see why clicking on the field in a table datasheet view results in nothing..
rgds
That's right!
That's not what I advised. You only need a textbox that's bound to the hyperlink field and in the Click event you fire the FollowHyperlink method. Yes, VBA not a macro.
I still would like to know why it's not working on your table. Can you upload a sample db?
