Hyperlink & #-sign

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a Word merge doc to use an Access query as a data source. The merge works fine with one exception. Hyperlink fields on the DB come out with leading and trailing #-signs. Is there a way to stop the #-signs?
 
Hi Mark,

Try changing the query. Use calculated fields for the hyperlink fields,
e.g.
fXXX: HyperlinkPart([XXX], 2)
where XXX is the name of the field. The argument 2 causes
HyperlinkPart() to return the hyperlink address; if you want the
hyperlink as it's displayed, use 0 instead. See VBA Help for more
information on the HyperlinkPart() function.
 
Back
Top