My client has a table that has a hyperlink field named Website. TI don't think that field can't be used in a query or report because it is a hyperlink. When I tried to copy this field and make another field that is text, it has # signs on both sides of the website. How can I search and replace the # character?

And, on a form, when the client adds a hyperlink, can i have it automatically fill the other text field?