HELP: Exporting from Access form to Word template and saveas word

[sam]

Hi All,

I am trying to create a button on access form that would export certain
information from access form to word template and save it as a word file.

The issue I am having is:
I have certain fields marked as hyper link in access database and when
trying to export those fields from accses form to word template I am able to
export the data but, I get something like this:
"124 South West St#http://124 South West St#"

I dont want the #http://124 South West St# part from the address.. is there
a way to just display 124 South West St?

Also, I get "Error! No document variable supplied." displayed on word file
for the field that has no value present in Access. Is there a way to get rid
of this error message and display a blank if there is no value persent for
that field in access?

Hope I made it clear.

Thanks in advance

 

[Arvin Meyer [MVP]]

Change your hyperlinks to text fields. There are other added benefits, such
as you can index them, as well. You can still use the hyperlink property of
a textbox to treat them as a hyperlink when they are actually text.