How can I restore the default color (Blue) of a hyperlink once it's been followed and the form is closed? When the form is re-opened, I'd like each hyperlink to be the default color of Blue. This way the user can keep track of what they've opened/followed while they're using the form.
I've experimented with Application.SetOption "Hyperlink Color", 12 on Open Event and now there's no change in color even for a followed hyperlink.
I've searched this forum, others and MS Help but haven't found anything that's of help.
I tried changing the fore color of the control on Event click, but that changes all values and not just the one that was followed. The hyperlink is in the detail section of the form and there are about 100 different records/values. Each one opens a unique PDF file. I need only the followed field values to change color and reset when the form is closed.