Hi all,
I have a form with a textbox linked to a hyperlink field which is used to ingest PDF files into a database (you drag the PDF on to the textbox, it copies the file from the link location to another specified location, renaming the file along the way).
That works fine for a new record. But where you're trying to add it to an existing record it doesn't: you can't drag the PDF on to the textbox. This seems to be because access already thinks there's a hyperlink there (even if the field actually empty and you've never added a link to it). To solve the problem, you need to right click on the textbox --> hyperlink --> remove hyperlink.
Is there a way to do that with VBA on (say) the form load event? It doesn't matter if it clears the hyperlink data from the record - that's never actually used (and indeed, the field only exists to allow this operation).
Cheers
I have a form with a textbox linked to a hyperlink field which is used to ingest PDF files into a database (you drag the PDF on to the textbox, it copies the file from the link location to another specified location, renaming the file along the way).
That works fine for a new record. But where you're trying to add it to an existing record it doesn't: you can't drag the PDF on to the textbox. This seems to be because access already thinks there's a hyperlink there (even if the field actually empty and you've never added a link to it). To solve the problem, you need to right click on the textbox --> hyperlink --> remove hyperlink.
Is there a way to do that with VBA on (say) the form load event? It doesn't matter if it clears the hyperlink data from the record - that's never actually used (and indeed, the field only exists to allow this operation).
Cheers