While you’re previewing a Microsoft Access report, you may
notice that many of the fields have been cut off at the right margin. You go in
and resize the field control to display the entire field’s data, but the column
of data for that field now prints on a second page. Changing the size of the
control has increased the overall width of the report, making it too large to
fit on a single page using the default margins. You need to reduce the size of
your margins so the last column of data is not forced on to another page.
Follow these steps:

  1. Double-click
    the name of the report in the database window.
  2. Click
    the Setup button in the Print Preview toolbar. (For Access 2000, choose File | Page Setup.)
  3. Change
    the left and right margins from one inch to .75, or lower as needed, and
    click OK.

Help users increase productivity by automatically signing up for TechRepublic’s free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.