• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Troubleshooting

Eliminating Empty Pages

Q1:When previewing or printing a report, Access displays or prints a blank page after each page with data.
A1: If a report's width becomes greater than the net printable width (the paper width minus the sum of the left and right margins), the number of report pages doubles. Columns of fields that don't fit a page's width print on a second page, similar to the printing method used by spreadsheet applications. If you set your right margin beyond the right printing margin or if the right edge of any control on the report extends past the right printing margin, the added pages often are blank. Change the printing margins or reduce the width of your report so that it conforms to the printable page width. (See the section “Adjusting Margins and Printing Conventional Reports” earlier in this chapter.)

Unexpected Parameters Dialogs

Q1:A Parameters dialog appears when changing to report Preview mode, but the query to which the report is bound doesn't have parameters.
A1: You misspelled one or more objects—usually text box or query field names—in expressions for text boxes or other controls that use calculated values. Click Cancel and verify that the expression in the Record Source property for each text box or other control on the report contains valid object names.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint