Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. ACC2000: Vertical Lines in Report Do Not Grow with Section

ACC2000: Vertical Lines in Report Do Not Grow with Section

View products that this article applies to.

This article was previously published under Q208429
This article applies only to a Microsoft Access database (.mdb).

Moderate: Requires basic macro, coding, and interoperability skills.

For a Microsoft Access 2002 version of this article, see 286247� (http://support.microsoft.com/kb/286247/EN-US/ ) .

↑ Back to the top

Symptoms

Vertical line controls do not increase in height when you place them in a report section even if you set the CanGrow property for the section to Yes.

↑ Back to the top

Resolution

Use the Line method to prevent broken lines if the report section grows. The following example uses the sample database Northwind.mdb to demonstrate how to use the Line method.
  1. Open the sample database Northwind.mdb.
  2. In the Database window, click Reports, and then click New.
  3. In the New Report box, click AutoReport: Columnar, click Employees in the Choose the table or query where the object's data comes from box, and then click OK.
  4. Set the OnOpen property of the report to the following event procedure:
    Private Sub Report_Open(Cancel as Integer)
   DoCmd.Maximize
End Sub
  5. Set the OnClose property of the report to the following event procedure:
    Private Sub Report_Close()
    DoCmd.Restore
End Sub
  6. Set the OnPrint property of the detail section to the following event procedure:
    Private Sub Detail_Print(Cancel as Integer, PrintCount as Integer)
    Me.ScaleMode = 1
    Me.ForeColor = 0

    'Repeat the following line of code for each vertical line
    '1 * 1440 represents 1 inch.
    Me.Line (0 * 1440, 0) - (0 * 1440, 14400)
    Me.Line (1 * 1440, 0) - (1 * 1440, 14400)
    Me.Line (1.9 * 1440, 0) - (1.9 * 1440, 14400)
    Me.Line (5.5 * 1440, 0) - (5.5 * 1440, 14400)

    'The 14400 is an arbitrary number to increase the line
    'to the max of a section.
End Sub
Preview the report. Note that the lines run from the top to the bottom of the page.

↑ Back to the top

References

For more information about the Circle method, please see the following article in the Microsoft Knowledge Base:
Q2103365� ACC2000: How to Use the Circle Method on a Report
For more information about the Line method, click Microsoft Visual Basic Help on the Help menu, type line method in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.

↑ Back to the top

Keywords: KB208429, kbusage, kbprb, kbdta

↑ Back to the top

Article Info
Article ID : 208429
Revision : 1
Created on : 12/12/2002
Published on : 12/12/2002
Exists online : False
Views : 340