I have a field in my table stored as a hyperlink datatype. I then have a button on a page that returns the path of a file into a text box which is linked to the hyperlink field in the table. If I type the path in from scratch, then it works, but if I use the button to return the path, then it only works if I do any kind of editing in the textfield on the form.
I need it to work first time without doing any kind of editing.
If I can't get that to work, then is there some code that I can use in a click event to get it to open a file?
You shouldn't need any additional code.. What do you have set for the target of your link? Also, what do you mean by "it only works if I do any kind of editing in the textfield on the form.", I don't think I've ever really run into that.