Urgent! '#' are automatically added when LINk is used

MS Access adds #Manuals/document1.doc# when field type is Hyperlink.
You need to fix this in the database. Avoid using MS Access Hyperlink data type at all costs.

thank you.

could you please guide me how to set the DB and the link field in ASP runner.

so that I will not have these again?
I am really lost.

thank you very much.

I have even used

custom as view as..
and typed there
strValue = "<a href=" & rs("Link") & ">" & strValue & "</a>"
but it did not make the LINK field a link.

just a quick note even though I did not yet solve my problem, and hope you guys can help i really need this.
in order to delete all charachters (in access database) located between "#" signs you have to use wildcards as follows:
for example: if you have
../Manuals/document1.doc#../Manuals/document1.doc#

../Manuals/document2.doc#../Manuals/document2.doc#

../Manuals/document3.doc#../Manuals/document3.doc#

......... ........

../Manuals/documentN.doc#../Manuals/documentN.doc#
open Access, open your table, clicn Find/Replace menu, and in the "Find" box type:
.doc*
in the Replace box type
.doc
and use Match any part of the field.
in this case
access will find and replace ALL charachters located AFTER the ".doc" however long they might be with (nothing)
at least I do not have to replace my 3000+ manually.
now back to my original question please.
I have already tried:

1. setting the Link field in access as memo(since the links posted are very long and are generrally longer than 255 charachters)
   
   and setting in visual editor Link field as hyperlink,with an option to display link as Word Link"
   
2. setting Link field as memo, and setting the field in a visual editor as HTML
   
3. setting Link field as memo, and using custom lines as:
   strValue = "<a href=" & rs("Link") & ">" & strValue & "</a>"
   
   or
   even
   
   strValue = "<a href=" & rs("Link") "</a>"
   I also tried
   setting Link field in ACCESS as a hyperlink, and hyperlink in visual Editor.
   all my attempts FAILEd.
   Could you please help?
   what is wrong.

You need to fix this in the database. Avoid using MS Access Hyperlink data type at all costs. Set field type to Text in MS Access and remove everything between #s.

Thank you, but _text field_will not accept anything longer than 255, how to go around it?

Use Memo field.