Troubleshooting

graphics/troubleshooting.gif

Eliminating Empty Pages

When previewing or printing a report, Access displays or prints a blank page after each page with data.

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

A Parameters dialog appears when changing to report Preview mode, but the query to which the report is bound doesn't have parameters.

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.



Special Edition Using Microsoft Office Access 2003
Special Edition Using Microsoft Office Access 2003
ISBN: 0789729520
EAN: 2147483647
Year: 2005
Pages: 417

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net