Hyperlink exported contains #'s

[Paul Robertson]

I am working off the jazzy custom Gothere button demo - (#33)
You have to export a URL. I am getting mine from an Access table with the field type "hyperlink". The url is turning up with a leading and trailing # character.

Any thoughts as to why this is happening and how to get rid of them?

regards

[John]

Hi Paul,

Maybe Access is putting them in for you.

First, you could try changing the
field to a simple text field (that's what ours is in the example). That
should do it.

Otherwise, you can manually strip off the &#34;#&#34; chars before doing the <A HREF..
part of your code and you&#39;ll be fine too. The neat Replace command could
strip our your &#34;#&#34;s in one command (assuming your string is in &#34;s&#34:

s = Replace(s,&#34;#&#34;,&#34;&#34

Take care,
John

------------
Paul Robertson at 9/5/99 5:13:10 AM

I am working off the jazzy custom Gothere button demo - (#33)
You have to export a URL. I am getting mine from an Access table with the field type &#34;hyperlink&#34;. The url is turning up with a leading and trailing # character.

Any thoughts as to why this is happening and how to get rid of them?

regards