I have a report that looks fine whe

[sdb0812]

I have a report that looks fine when I view it in Access. The problem I am having is I allow users to email reports and when this is done, the formatting of the report gets distorted. I email the report as an email attachment using the sendobject and formatted as rich text.

Any ideas as to what is causing the report to become rearranged and how to fix it??

thanks,
Scott

 

[randysmid]

Hi,
You may want to print the report as "snapshot". Then send the snapshot file (ReportName.snp) to your users as an attachment. The only gotcha is that they must have the snapshot viewer program on their computer. This program is called Snapview.com, and can be downloaded from Microsoft at no charge. It is a stand-alone program, and does not require Access. Here is the link to the Microsoft topic:

http://support.microsoft.com/default.aspx?scid=kb;en-us;175274

HTH,
Randy Smith
California Teachers Association

 

[sdb0812]

Thank you for the response. I think I found the problem. For some odd reason, the text boxes in the report were different sizes and that is what was causing the formatting problems. I manually made all the boxes the same size and then it worked fine. I am going to try your method too.

scott