Hyperlinks - not working with 'Open File' button

[Knackers]

Greetings Access gurus.
I have a form that has a feild for hperlinks. To make this easier for the user to insert a hyperlink in this field I have a button that allows you to browse for a file using a common dialogue box and module.

This all works fine, but when using the button, the file path returned looks like C:\mydocuments\documentname.doc While this appears to be a hyperlink in the box (underlined and blue), when you click on it, the link does not work.

However, if you use the Insert>Hyperlink from the menu bar, the same file appears as ..\..\My Documents\documentname.doc and it works fine.

Can anyone tell me if there is a way that I can get the common dialogue for the 'Open' button to delive the file path in the correct format for a hyperlink?

Cheers

 

[NRK]

Did you ever find a solution to this issue? I am in the same situation, but haven't found a solution.

 

[Knackers]

Hey - I had trouble even remembering what project I was working on it was that long ago. I think that I ended up just documenting the fact that you had to use the Insert>Hypelink command.

I did remember seeing a simmilar problem that said the use of H-Keys was the solution. I am not even all that sure of what they are.

Sorry I couldn't be of more help.

 

[NRK]

It's OK...thanks for responding so quickly.