Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2020
    Posts
    3

    Question Stretching drawn items in Reports


    I want to stretch drawn lines in report design so that when a field is set to "Can Grow" the line adjacent to it used as a column separator, will grow too, is this possible?
    Phil

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    You could try this in the ON PRINT event,
    line1.height = object.height

  3. #3
    Join Date
    Feb 2020
    Posts
    3
    Thanks, I tried a couple of ON Print event trials but can't get it to accept as a code... I'm not familiar with code, only wizards etc. though.

    Snapshot of what I'm trying to achieve below
    Click image for larger version. 

Name:	Capture Q Record.JPG 
Views:	6 
Size:	17.3 KB 
ID:	40951

  4. #4
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    or you can use the line property - see this link http://etutorials.org/Microsoft+Prod...hrink+Control/

    or google 'access vba vertical line in report' to find other examples

  5. #5
    Join Date
    Feb 2020
    Posts
    3
    Quote Originally Posted by Ajax View Post
    or you can use the line property - see this link http://etutorials.org/Microsoft+Prod...hrink+Control/

    or google 'access vba vertical line in report' to find other examples

    Thanks Ajax,

    I think it will be a tall task for me (with the coding) but I can see that it should be achievable.... Could be a long night!

    Great reply,
    Thank you,
    Phil

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

Similar Threads

  1. Replies: 6
    Last Post: 12-02-2019, 10:17 PM
  2. Stretching outline
    By Perfac in forum Reports
    Replies: 4
    Last Post: 06-29-2018, 04:58 AM
  3. No relationship drawn connecting tables
    By vector39 in forum Database Design
    Replies: 1
    Last Post: 10-13-2017, 03:46 PM
  4. Replies: 4
    Last Post: 11-18-2013, 03:23 AM
  5. Replies: 1
    Last Post: 07-19-2011, 05:45 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