If retaining the formatting is important, and you are mostly concerned with
distribution of the report (editability aside) to non-Access users you could
look into "printing" the report to a *.pdf. Then you could still distribute
the report electronically. Obviously you would need Acrobat for this.