Fax formatting issue

R

RKN

I have an Access app that dynamically sends faxes using the fax object and
the Windows XP faxing functionality. From what I've seen on the boards, the
only way I can do this with minimal user intervention is to first save the
report off into a .rtf file. My problem here is that the pages in the report
often go larger than the resultant .rtf file. So that where page 1 of my
report my actually end up with the bottom records on page 1 showing up on
page 2 of the .rtf file (then page breaking for page 2 of the report and thus
several pages with only 1 or 2 lines and then blank for the rest of the page.

Does anyone know of a formatting way to avoid this or how I can do the same
steps in the Faxing Wizard through VBA code in Access so I can send the
report straight to fax with the faxing information supplied by the Access
app? Thanks
 
Top