Hyperlink field doesn't work 1

[ktb916]

I have written a program that gets a file path and puts it in an access table field that is formatted as a hyperlink. I want to be able to use the hyperlink to open the file. The data in the field looks and behaves correct (it's formatted correctly and the pointer turns to a finger when hovered over the field) but it doesn't work. Interestingly enough if I change any letter in the field (basically just type over one character) it works. What's missing?

[rcd1!FilePath.Value = filFile.Path]

 

[PHV]

And what about this ?
rcd1!FilePath.Value = "#" & filFile.Path & "#"

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[ktb916]

Simple and effective - thanks for the help!