Would like clarification on parts of the thread.
Is the issue that you are trying to open a word document:
- based on a file name stored in a table
- based on user choosing a file with the file dialog selector
- based on a textbox on a form
- other?
Sounds like you are trying to use follow hyperlink to open the word doc. Are you only opening word docs?
I tested out an alternate method to open a word doc in a folder and file name both on hard disk and a network drive with spaces dashes and # and seems to open fine, so based on answers to above can provide some sample code that may work for you. If there other file types, then additional logic would be needed to determine which application to open the file with.
If that doesn't interest you, something else you could try:
I couldn't find my follow hyperlink code to test a theory, but you may also try wrapping the text string in quotes either before or after, something like one of these may work?:
# & chr(34) & me.location & chr(34) & #
"# & me.location & #"
chr(34) & # & chr(34) & me.location & chr(34) & # & chr(34)
