ACC: How to Determine Which Snaking Column Is Current

Last reviewed: May 14, 1997
Article ID: Q123712
The information in this article applies to:
  • Microsoft Access versions 2.0, 7.0, 97

SUMMARY

Novice: Requires knowledge of the user interface on single-user computers.

This article describes how to determine which snaking column in a report is current. This determination is useful for:

  • Setting columns so that each has an equal number of items.
  • Drawing separation lines between the columns.

MORE INFORMATION

You can determine which column is current by checking the report's Left property. In a report with snaking columns, the Left property value is always greater in the second column than in the first column. For example, assume a report with the following dimensions:

   Left margin: 1 inch
   Right margin: 1 inch
   Report width: 3.5 Inch
   Column spacing: 0
   Items across: 2

In the first column, the report's Left property is 1 inch. In the second column, the report's Left property is 4.5 inches (left margin + report width = second column Left property). Note that values in the Left property are measured in twips. One inch contains 1440 twips.

You can determine if the second column is current without knowing the report's dimensions by comparing the value of the Left property with the width of the report. If the value of the Left property is greater than the width of the report, the second column is current. Note that this method works only if you click the Same As Detail check box in the Page Setup dialog box (or Print Setup in version 2.0). To verify the Same As Detail option setting, open the report in Design view, and then:

   In Microsoft Access 97:

      On the File menu, click Page Setup, and then click the Columns tab.

   In Microsoft Access 7.0:

      On the File menu, click Page Setup, and then click the Layout tab.

   In Microsoft Access 2.0:

      On the File menu, click Print Setup, and then click the More button.

You can use this information in conjunction with the report's OnFormat property to perform a variety of tasks, such as ensuring that each column has an equal number of items, and drawing lines between the columns.

NOTE: For an example of using the Left property, please see the Sales Averages report in the Developer Solutions database, Solutions.mdb (or Solution.mdb in version 2.0), included with Microsoft Access. The Sales Averages report is a multiple column report that prints the labels in the first left-most column of the report. The data prints in the columns after the labels. For a code example, see the ShippedDate Header OnFormat event procedure in Design view of the Sales Averages report.

REFERENCES

For more information about snaking columns, search for "snaking columns in reports," and then view "Create a multiple-column report," using the Microsoft Access 97 Help Index.


Keywords : kbusage RptWizsn
Version : 2.0 7.0 97
Platform : WINDOWS
Hardware : X86
Issue type : kbhowto


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: May 14, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.