I have a value stored in a table as a hyperlink datatype.
On the form, I have a button that returns the path of the file into a textfield on the form which is linked to the table.
The link doesn't do anything when I click on it, but if I delete a character and then replace it... then it works.
how can I change this so that it always works?
Also if I type the link in, then it works immediately.