Hyperlink option not available, Help please!

[foconn_ms3]

Hi there,
I'm having a bit of trouble with one of my forms. I have a main form called "frmNewProperty" on which there are a number of text boxes and combo boxes the values of which are bound to two different tables "tblAddress" and "tblProperty". Three of the text boxes have their "Is Hyperlink" set to Yes. The tblProperty table has these fields set up as Hyperlinks too.
However ... when I right-click on the text boxes the Hyperlink option is greyed out so users can't enter a new hyperlink????
Can anyone tell me why this is?
Many thanks,
Fi

 

[Meltdown]

My personal opinion, it's not a good idea to assign fields as "hyperlinks" because it prevents the user from entering or modifying the field on the form. I leave the fields as text fields and put a "GO" button beside the field, then call a function.

See attachment (A2K)

 

[foconn_ms3]

Hi,
Thanks for the speedy reply ... I probably should have mentioned that in some cases, the users will want to enter a file location in here rather than a web address. I need them to be able to browze a directory if they, say, right-click on the field? Any ideas?

 

[Meltdown]

Download the sample DB from this thread, all about accessing files and folders...
http://www.access-programmers.co.uk/forums/showthread.php?t=66195&highlight=folders