I have a field in my table that needs to contain a hyperlink. What I would like to do is to allow the user to Browse and Select the folder related to the record when the record is created (or create a new folder). Then when the record is browsed, the hyperlink can be clicked to open the folder.

Do I put this hyperlink in the table as a 'hyperlink'? Or do you put it in the form? Or is it better to create a command button?

Hope you can help!

Not sure if this would help; I'm relatively inexperienced.

To set a field (column in your table) as a hyperlink, you open the table in design view and change the data type of the relevant field to "hyperlink". In datasheet view, insert the hyperlink for a record by: right click -> Hyperlink -> Edit hyperlink. The file can be selected and one can choose the text to be displayed in the cell of the table, as well as the screen tip that appears when one does a 'mouse-over'. When the hyperlink is clicked the file opens. Or the link can be added through a form too, like the other fields, using a text box. Then right click, and the process above applies.

:)

Thank you so much for the info! Is there a way to set up the form so that the user doesn't have to do the right click and edit thing? Perhaps with a button or something? But then the hyperlink would need to show so that they can access it when they next open the record. Hope that made sense.

Double post

You're welcome..
Yes that is possible. I found this through Google.. I don't really know how it all works as I'm still new to programming, but it did when I tried it.
http://www.utteraccess.com/forums/printthread.php?Cat=&Board=89&main=1611468&type=thread
This is the site it's linked to:
http://www.mvps.org/access/api/api0001.htm

When a hyperlink is added it should be visible, both in the relevant cell of the table and in the text box of the form. Regarding the tab order, I'm sorry I don't know..

Thanks again!

You're welcome again!
Good luck :)