Results 1 to 4 of 4
  1. #1
    chum is offline Novice
    Windows XP Access 2002
    Join Date
    Oct 2009
    Posts
    5

    Can Grow Property

    In a report, I insert horizontal and vertical lines. When I set the property “Can Grow” to Yes, and the entry wraps around and makes the record wider vertically, the vertical lines in that particular record no longer touch the horizontal line below it. Can this be fixed?

  2. #2
    ChrisO is offline Novice
    Windows XP Access 2003
    Join Date
    Aug 2005
    Location
    Brisbane, Australia
    Posts
    27
    Have you tried drawing the vertical line with a height of 32700 twips?

  3. #3
    chum is offline Novice
    Windows XP Access 2002
    Join Date
    Oct 2009
    Posts
    5
    How do you do this?

  4. #4
    ChrisO is offline Novice
    Windows XP Access 2003
    Join Date
    Aug 2005
    Location
    Brisbane, Australia
    Posts
    27
    Have a play with changing some the values in the following code and also look up the help file on the line method.

    Code:
    Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)
        Dim lngTop    As Long
        Dim lngLeft   As Long
        Dim lngRight  As Long
        Dim lngHeight As Long
        
        lngTop = 0
        lngLeft = 0
        lngRight = 8200
        lngHeight = 32700
        
        Me.DrawStyle = 0
        Me.Line (lngLeft, lngTop)-(lngLeft, lngHeight), vbBlack
        Me.Line (lngRight, lngTop)-(lngRight, lngHeight), vbBlack
    
    End Sub

Please reply to this thread with any new information or opinions.

Similar Threads

  1. the property is read only and cannot be set
    By darksniperx in forum Access
    Replies: 16
    Last Post: 11-02-2012, 02:48 PM
  2. Can Grow Property
    By MFeightner in forum Reports
    Replies: 0
    Last Post: 06-24-2009, 11:50 AM
  3. Property Sheet issues
    By Tim in forum Access
    Replies: 1
    Last Post: 05-28-2009, 08:35 PM
  4. Alternative to Join Property???
    By arthura in forum Queries
    Replies: 1
    Last Post: 05-22-2009, 12:17 AM
  5. 'On Open' Property
    By emilylu3 in forum Forms
    Replies: 1
    Last Post: 12-08-2005, 02:28 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums