INF: Reports Questions & Answers
  
PSS ID Number: Q104388
Article last modified on 02-07-1995
 
1.00 1.10
 
WINDOWS
 

---------------------------------------------------------------------
The information in this article applies to:
 
 - Microsoft Access versions 1.0 and 1.1
---------------------------------------------------------------------
 
======================================================================
  Microsoft® Product Support Services Application Note (Text File)
                  WX0640: REPORTS QUESTIONS & ANSWERS
======================================================================
                                                   Revision Date: 9/93
                                                      No Disk Included
 
The following information applies to Microsoft Access®, versions 1.0,
and 1.1.
 
-----------------------------------------------------------------------
| INFORMATION PROVIDED IN THIS DOCUMENT AND ANY SOFTWARE THAT MAY     |
| ACCOMPANY THIS DOCUMENT (collectively referred to as an Application |
| Note) IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND, EITHER      |
| EXPRESSED OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE IMPLIED      |
| WARRANTIES OF MERCHANTABILITY AND/OR FITNESS FOR A PARTICULAR       |
| PURPOSE. The user assumes the entire risk as to the accuracy and    |
| the use of this Application Note. This Application Note may be      |
| copied and distributed subject to the following conditions:  1) All |
| text must be copied without modification and all pages must be      |
| included;  2) If software is included, all files on the disk(s)     |
| must be copied without modification (the MS-DOS®  utility         |
| diskcopy is appropriate for this purpose);  3) All components of    |
| this Application Note must be distributed together;  and  4) This   |
| Application Note may not be distributed for profit.                 |
|                                                                     |
| Copyright (C) 1992-1993 Microsoft Corporation.  All Rights Reserved |
| Microsoft, Microsoft Access, and MS-DOS are registered trademarks   |
| and Windows is a trademark of Microsoft Corporation.                |
|---------------------------------------------------------------------|
 
1.  Q. Why is every other page of my report blank? How can I correct
       this problem?
 
    A. This problem commonly occurs when the width of your report
       combined with the left and right margins is greater than the
       width of your paper. Adjust the width of your report and the
       margins so that your report fits on the page.
 
       For additional information on preventing blank pages, please
       obtain Technical Note #95920. You can order this technical note
       by selecting the FastTips Technical Library option from the
       FastTips Main Menu.
 
2.  Q. How can I convert a form to a report?
 
    A. To convert a form to a report, open the form in Design view and
       choose Save As Report from the File menu.
 
3.  Q. How can I sort the data in a report by a field not displayed on
       the report?
 
    A. To sort report data by a field in a separate table, create a
       query that includes the field from the other table, then base
       the report on the query. If you have already created the
       report, verify that the query includes all the fields used in
       the report and change the RecordSource property of the report
       to refer to the new query. Now you can adjust the Sorting and
       Grouping properties of the report to sort on the new field.
 
4.  Q. How can I prevent a page break from occurring in the middle of
       a group?
 
    A. The KeepTogether property keeps all the controls for one record
       together within a particular section of a report. However, it
       does not keep multiple records together, nor does it keep a
       group header and its detail records together.
 
       The following methods can prevent page breaks from occurring in
       the middle of groups:
 
        - Set the ForceNewPage property of the report's Group Header
          section to Before Section. This ensures that each group will
          start on a new page and that as many detail records as possible
          will fit on one page.
 
        - Repeat the group name, or place a "Continued" label at the top
          of each consecutive page.
 
          For additional information on how to create these labels
          for consecutive pages of a group, please obtain Technical
          Notes #88156 and #93927. You can order these technical notes
          by selecting the FastTips Technical Library option from the
          FastTips Main Menu.
 
        - Before placing the group header on the current page, create an
          Access Basic function that calculates how much space is left on
          the page.
Additional reference words: 1.00 1.10
KBCategory: kbusage kbfasttip kbappnote
KBSubcategory: FstQa
=============================================================================
Copyright Microsoft Corporation 1995.
