Missing Borders from Access Export to .rtf

[Guest]

I see that several others have posted similiar problems (often about logo's)
not being exported from the Access convert to .RTF format. The standard
answer is to use snapshot or pdf. That is fine for view, but not very
helpful to allow someone to edit reports originally generated from Access.
Since .rtf is fine with borders and even Access understands borders when
exporting to .xml, and this seems a pretty reasonable and common expectation
to be able to export are there plans to have this oversight corrected?
Or does someone know of a porting tool from .XML to .RTF that will
maintain the borders?
Regards,
mmi

 

[John Spencer (MVP)]

Only Microsoft knows if they are going to change this behavior.

If it is important to you to be able to modify the information after exporting
it, you might look into using automation. MVP Albert Kallal has some good code
to create Word Merge documents based on Word and Access. That may be of use to
you.

This URL used to be good, but I have not checked it in quite some time.

http://www.attcanada.net/~kallal.msn/msaccess/DownLoad.htm

Also, you can check out Stephen Lebans' site for some possible solutions.

www.lebans.com

Specifically

http://www.lebans.com/ReportUtilities.htm

ReportUtilities a suite of utilities with 5 Features:
1) Export to MS Word. Output exact duplicate of a Report to RTF, including
formatting and all graphics. This file can be loaded into MS Word for limited
further editing or inclusion into a larger document.

2) Export to WordPad. Output duplicate of a Report to RTF, including formatting
and all graphics. This file can be loaded into MS WordPad for viewing and/or Printing. 

3) Save Report to Enhanced Metafile format. One EMF file for every Page of the Report.

4) Save Report to the older Metafile format. One WMF file for every Page of the
Report. This format may be imported by FrontPage as a Clip and then saved to the
Web page as an WMF not a GIF or JPEG! This means about 10KB to 15KB average per
Report Page.  

5) Print To Fit functionality. Output multiple Report pages per single output
page. 2up, 3up or 4up etc.  Printer selection is independent of the original
Report.  For instance you could output a Report of Legal size pages to standard
Letter size. Does not require MS Word.


The code allows you

 

[Guest]

Thanks. I found Albert Kallal's material at
http://www.members.shaw.ca/AlbertKallal/ Have not yet applied it, but it
looks positive.
(Prior to your reply, I did find other word merge examples, but have not
yet figured out how to handle the fact that in my form one of the fields is
from a sub-form(?) with has a 1 to many relationship to the main report.
Works great in access or if I were to send the print to .pdf, not so good
with telling word to pull in the fields.)

Cheers,
- mmi