Convert Hyperlink field to Text

[izzo248]

I made a table with a hyperlink field called Title, which I'd intended to use to link to documents residing in my computer. After entering a lot of data, I've decided it was a bad idea because Access automatically creates an http link that doesn't exist.



I'd like to convert the field to plain text. When I simply change the data type, the result is the whole link spelled out. If I try right-clicking and choosing "Remove hyperlink", Access removes the contents of that field entirely. Anyhow, removing one link at a time would be cumbersome because the table contains over 400 records.

Is there a way I can remove all of those link in the table, leaving only the Title?

Thanks in advance for any help that can be offered.
Izzo

[June7]

Hyperlink are composed of 3 parts. Review http://www.allenbrowne.com/casu-09.html

Use string manipulation functions to extract the title and populate field in an UPDATE query.

[izzo248]

Not sure what you mean by string manipulation functions. The titles are repeated in the hyperlinks, which look like this:
Apology#http://Apology#
I'd need to delete from the first # to the end of the string. Is there a wildcard that does this?

[June7]

No wildcard will help.

String manipulation functions: Left, Right, Mid, InStr, InStrRev, Len

Appears you want the 'display text' part.

Left([fieldname], InStr([fieldname], "#") - 1)