displaying hyperlink in automation to Word

[SUZYQ]

I have a field in a table that shows hyperlinks with a different
caption (i.e. if the web address is www.pbs.org, I display the link as
"PBS"), but when the user clicks on the link, it takes them to the
correct address.

Using VBA and automation, I want to create a document in Word with the
data from Access. The document contains some text from another field,
but then I want to display the hyperlink and have it look right. The
code is:

strBodyIntro = strBodyIntro & " " & rsClips!HyperlinkNew & " " &
vbCrLf

When I do that instead of the proper display I get:

PBS#www.pbs.org.

Please help.