from a table. The hyperlink works fine in the table, but clicking on it as viewed on the form does nothing. yes, the hyperlink property of the text box is set to Yes.

this is, btw, a link to a spreadsheet and named range. Worked fine in Access 97. Now using A2K and no luck!

Use this code on the onclick event of the textbox. The me.txtBox bit is the value of the box as I guess that it changes for each record.

Dim HypLink As String
HypLink = "F:\D$\private\nix\" & me.txtBox
Application.FollowHyperlink HypLink, , True

Otherway is to use a listbox then people can scroll through all available files and double click on the one that they want. Stick the code into the OnDbleClick event and change the me.txtBox to me.lstBox.Column(x) where x is column in the listbox (holding the filename) - 1 [ie first column is column(0)]

HTH

Thanks, tried that and no dice.