Access does not have a "shrink to fit" like Excel (unless Access 2007 has added
this). There are printer drivers that would let you do that irrespective of the
program doing the printing though.
How about setting your report up such that it all fits on a single page? If
you are only printing a single record this should be achievable... if you are
printing a variable number of records each time this might be a bit harder to
achieve...