hyperlink not working? 1

[Bullsandbears123]

I have a hyperlink in a form and when I click on it to open the file/webpage nothing happens. What needs to be set to get hyperlink to work?
I have already set the text box hyperlink property to yes, also the field the data is stored in is a Hyperlink.

THanks

ps. I know my links are correct and if I retype the address in the form then click it, it works. Weird uh?

 

[Bullsandbears123]

Let me add one more thing..

The hyperlink address is automatically input by code using

rst.Edit
rst.Fields("Path&quot.value = Path
tblrst.Update

Could this be the reason?

And if so How can I fix the problem?

 

[Bullsandbears123]

Any Idea? PLEASE HELP!!!!

 

[rou13]

Are you using Access 97? If so, check your settings under Tools=>Options=>Keyboard=>Arrow Key Behavior. If that is set on 'Next Character', this may be causing the problem. Change it instead to 'Next Field'. There is a bug here - something about the settings related to these two functionalities - hyperlinks and arrow key behavior - mistakenly sharing the same key in Windows Registry in Access 97.

 

[BillPower]

Try using the hash sign like this:

rst.Edit
rst.Fields("Path&quot.value = "#" & Path
tblrst.Update

Bill

 

[Bullsandbears123]

THANKS, the "#" works wonders!