Editing hyperlink field

[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?

 

[Len Boorman]

You have to be careful if you intend to edit hyperlinks via say a query.

It is a simple matter to concatonate a string from various fields and update a Hyperlink field with teh resulting value and it all looks okay, but probably doesn't work.

Tip add # (yes a hash) to each end of the string you are creating as the hyperlink.

This is buried so deep in the Help that is nearly impossible to find unless you know what you are looking for. Then of course you do not need to find it

Len