Edit Hyperlink Not Available In Form

[LarryB]

Hi all,

Im about to release a small app and after some testing I have found that my hyperlink options are not available, when the field is right clicked - see attached screenshot

I have removed all security features (Tools Startup), code from the form_load and form_current - but this issue is across multiple forms where I have the hyperlink option available so I believe this is something I have applied on the startup of the app

I have regularly saved my db so I can back track if necessary, but in this case, it is a month of work I'll have to roll back to get the hyperlink options available!

If anyone could offer some advice it would be much appreciated

Many thanks

LarryB

 

[vbaInet]

If you create a new Hyperlink field in the table and scribble down some URL does it come up with that option?

 

[LarryB]

Unfortunately not. Adding a new text box to the form no options were available.

After looking at this with a fresh pair of eyes this morning I found the problem

Part of my macros, modules, and switchboard startup, I have code in place to hide the entire MS Access window. I want to avoid creating an MDE. Since I was bypassing the startup by holding shift, I didn't think this code was having an impact, and it wasn't which is why I did not bother looking at this solution I have in place

Part of the above solution is to set the Popup property of the form value to Yes. Once this was set back to default or no, hey presto, my design view was back and I can edit hyper links.

Looks like I'll create the MDE file afterall

What I've learned .....sleep on it before posting up!!!

 

[vbaInet]

Good to know it's resolved.