I have got a weird thing going on here and I am stumped. I wonder if anyone could help me out.
I have an Access 2000 database of mp3 audio files
One of the fields has the name of the audio file (eg - AudioFiles\1234.mp3). This is set up as a hyperlink data type. If I click on the name in the text field in the form - the audio file plays in Windows Media Player. That is fine!
I have always entered the audio file name by copying it from somewhere else and pasting it in the text field in the form. That has obviously worked.
Copying and pasting is boring so I wrote some code to calculate and put the very same audio file name in the text field - but it does not work as a hyperlink. Copy and paste it again - and it works as a hyperlink to open the audio file just as before. It looks just the same. Weird.
I suspect that some additional hidden characters are going in without me knowing. Sometimes I see hash signs (#) around the text or at the end, which may be ominous - why are they appearing? I strongly suspect I am missing something obvious here. I have tried chopping off characters with Left but that just chops off visible characters - nothing works.
I should be grateful if any one has a solution to this.
I have an Access 2000 database of mp3 audio files
One of the fields has the name of the audio file (eg - AudioFiles\1234.mp3). This is set up as a hyperlink data type. If I click on the name in the text field in the form - the audio file plays in Windows Media Player. That is fine!
I have always entered the audio file name by copying it from somewhere else and pasting it in the text field in the form. That has obviously worked.
Copying and pasting is boring so I wrote some code to calculate and put the very same audio file name in the text field - but it does not work as a hyperlink. Copy and paste it again - and it works as a hyperlink to open the audio file just as before. It looks just the same. Weird.
I suspect that some additional hidden characters are going in without me knowing. Sometimes I see hash signs (#) around the text or at the end, which may be ominous - why are they appearing? I strongly suspect I am missing something obvious here. I have tried chopping off characters with Left but that just chops off visible characters - nothing works.
I should be grateful if any one has a solution to this.
