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

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

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.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com



"sam" wrote in message
...
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