I tried posting this in another group, with no results, so I'm trying
again...

I need to store a hyperlink to the location of filenames in the
database. I have been successful in storing the information (so far) by
assigning the field the required values separated by hash marks (#, or
pound signs or whatever you want to call them). Since Access requires
the # as the separator, I don't have an option to use another
character.

I have a text field on the form with a Browse button. The user selects
the file, using the browse button, and I store it in the text field as
follows:
Me.txtContractLocation = strPath & "#" & strPath

This shows the full path as well as creating the hyperlink so the user
can click on it.

Now that it's working, I found a document (among the test documents the
user gave me) that has a name which has a hash mark in it called "File
Test #1.jpg". Needless to say, this totally screws up my current
method.

So, NOW what do I do???

I know, I know, tell the users NOT to use stupid names (but try telling
that to a bunch of engineers!).

Thoughts, comments, solutions???

Thanks,
Larry

BTW, Access 2003, Windows XP

OOPS! Sorry, wrong news group.