I'm probably going to embarass myself because I'm a COMPLETE novice with VBA... and I'm not even sure if what I'm posting will make any sense!
I'm wondering if your data types are messing things up at all?
You mentioned a text box, is the data type an integer or text?
:confused:
Re: Access 2007 Hyperlink not working (Add "#" (no quotes) before and after text)
Solution that worked for me: format the hyperlink text with a leading and trailing "#" (no quotes) #\\drive\folder\filename.pdf#
I had a similar issue. I wanted a hyperlink for users to click that will open a...