Update a hyperlink

[DAW]

Is there any way to edit the hyperlink field in my table, I'm thinking along the lines of an update query?

The database has thousands of records and the user has not typed any text into the 'Display Text' part of the hyperlink. This means that the stored hyperlink is double size because if no text is entered into the display text part then access uses the hyperlink string. This is a problem for me later on in the design.

I have tried a simple update query and this updates the display text as required but also loses the hyperlink itself, which I want to remain unchanged.

Any ideas?

 

[workmad3]

probably looking at a VBA function that allows you to get the value currently there in a select statement, then use that with the extra in a seperate update statement.