exporting graphics to Word

[Chris]

I'm using Access 2000 (XP pro). I have a lot of reports that include graphics
(check boxes, text boxes etc) that don't export to Word. I'm trying to find a
way to send reports as email attachments to non-access users. Is there an
easy way to change the check boxes to Yes No & remove the text boxes without
redesigning each report? I'm a novice user & can't risk damaging the data.

 

[John Nurick]

Hi Chris,

There isn't a shortcut: you'd need to create another version of the
report in which each of the checkboxes was replaced with a textbox, with
expressions such as
=IIf([XXX]=-1,"Yes","No")
and the other elements that don't get converted to Word removed.

Alternatives include:

1) export to Snapshot format. This requires users to install the free
Snapshot viewer but ensures that everything in the report comes through
properly.

2) use Stephen Lebans's Report Utilities (www.lebans.com). These do a
far better job of exporting to Word than the standard export routine,
although the resulting document isn't very easy to edit.

3) use third-party software (e.g. Acrobat Professional, CutePDF, PDF995)
and send the reports as PDFs.

 

[Chris]

I suspected it wouldn't be easy. Can't use snapshot as reports go to people
all over the world, they don't have snapshot viewer & I can't ask them to
download it. But I'll try the other two suggestions.
--
Thanks for the help.

Hi Chris,

There isn't a shortcut: you'd need to create another version of the
report in which each of the checkboxes was replaced with a textbox, with
expressions such as
=IIf([XXX]=-1,"Yes","No")
and the other elements that don't get converted to Word removed.

Alternatives include:

1) export to Snapshot format. This requires users to install the free
Snapshot viewer but ensures that everything in the report comes through
properly.

2) use Stephen Lebans's Report Utilities (www.lebans.com). These do a
far better job of exporting to Word than the standard export routine,
although the resulting document isn't very easy to edit.

3) use third-party software (e.g. Acrobat Professional, CutePDF, PDF995)
and send the reports as PDFs.

I'm using Access 2000 (XP pro). I have a lot of reports that include graphics
(check boxes, text boxes etc) that don't export to Word. I'm trying to find a
way to send reports as email attachments to non-access users. Is there an
easy way to change the check boxes to Yes No & remove the text boxes without
redesigning each report? I'm a novice user & can't risk damaging the data.