Hyperlink Field with # in File Name

Question

Is there a trick to allow files with a # in their name to be opened via the hyperlink type field in Access?

Answer 1

Probably not since # is part of the URL spec and that is interpreted as a fragment.

However, you could disable the default behaviour of the control that display the link and simply use the onclick event to open the link any way you want, using the shell command for instance.