I have a hyperlink field on a form. I would like to intercept the error that is produced when the hyperlinked document no longer exists and stop MS Access from actually trying to connect/open this hyperlinked document. I can write code in the on_Click events but on_error doesn't seem to do anything.

How can I turn off the hyperlink action for a hyperlink field on demand?