Hyperlink not opening when character count is around 100+

[Anjani]

Hello.. I have a form in MS access 2003 which has a browse button and a hyperlink box next to it. The path gets saved in the hyperlink box which is selected using the browse button. When i click on the hyperlink, it should open the path of that file. It works absolutely fine for less than 100 characters (approx number), but blows up when 100+ characters are saved. Then, instead of opening the exact file path, it opens "MY DOCUMENTS". Please help. Very important and urgent

[NeoPa]

Strange. Can you post example data for entries that work and also for some that don't work. You give us almost nothing to work with.

[Anjani]

Hey NeoPa.. Thanks for the reply and concern.. the problem was that there were special characters used in the path i.e. File name.. and hence it would direct me to My Documents.. I figured it out.. Thanks anyways :D

[NeoPa]

8-)

That would probably have shown up with the example data, but no need for that now. Merry Christmas :-)

[Anjani]

Happy New Year to u and your family NeoPa...