Changing a table field data type to hyperlink via code (w/o design view)

[Faction21]

I have been looking for a way to modify a tables structure so that a text field, or memo field may be changed to a hyperlink data type without changing it via design view.

Currently, I am playing with the GetFiles sample database, and i grap a file path coresponding to a file. I would like to be able to click on the path in the table so that it opens the file (an image).

If i use the GetFiles function, it adds to the records in the 'path' field. Then I must change the table structure to have field 'path' to a hyperlink type so that i can open the file.

If I change it to hyperlink first, when the database adds the records, the hyperlink does not work, you cant even click it although its blue and underlined.

So does anyone know of a proceedure that allows this hyperlink field to work, or how to change a tables structure back and forth via code?

I know this makes little sense, so ask away if I dont.
-Thanks for any repsonses.

 

[Tim L]

I'm not sure about the other mechanics but do know that information stored in hyperlinkfields have #'s placed at the start and end of the stored value. If perhaps you could add them and re-store the values then the hyperlinks might then work correctly.

You might be able to utilise an update query to carry this operation out.

HTH

Tim