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