Results 1 to 2 of 2
  1. #1
    Tom Duffy is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    May 2018
    Posts
    1

    Automatically resize a line lenght when another "can grow" field grows

    I am using lines to separate some Field groups on a Report .I am hoping someone can show me how to get lines to grow automatically when another field "grown" on a report line .



    I have some experience with VBA , so a programming solution would be OK .


    Many thanks in advance .


    Tom D

  2. #2
    Minty is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,003
    I assume you mean Vertical or horizontal lines not associated with a text box ?

    If so, in the OnFormat event you can get the height / width of the "growing" control using Me.YourControlName.Height and set the other lines to that size.
    Generally this is a bit of a mare to get right, but persevere.
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

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

Similar Threads

  1. Vertical Line grows when when fields grow
    By trident in forum Reports
    Replies: 4
    Last Post: 04-28-2016, 02:25 AM
  2. Replies: 2
    Last Post: 12-09-2014, 09:24 AM
  3. Replies: 5
    Last Post: 11-23-2014, 03:54 PM
  4. Replies: 4
    Last Post: 07-12-2014, 02:02 PM
  5. Replies: 1
    Last Post: 04-05-2012, 08:26 AM

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