Results 1 to 6 of 6
  1. #1
    markjkubicki's Avatar
    markjkubicki is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Jul 2010
    Location
    Fire Island Pines, NY
    Posts
    496

    too much space between textboxes

    on a report, I have (3) textboxes stacked (one above the other)


    each control may or may not be visible (VBA), and may have a few characters or a several lines of text
    each is 0" height, 0" top and bottom margin, 0" top and bottom padding, line spacing 0" (font: Univers CE 45 Light 9pt normal)

    they are located at (top) 0000", .0417", & .0833"

    when the report displays, there is TOO MUCH SPACE BETWEEN THEM (top to bottom); and too much space above the top control also.

    How can I shrink the vertical spacing?

    with many thanks in advance,
    mark

  2. #2
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    My first suggestion would be to check out the "Can Grow" and "Can Shrink" properties for the text box controls.......

  3. #3
    markjkubicki's Avatar
    markjkubicki is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Jul 2010
    Location
    Fire Island Pines, NY
    Posts
    496
    forgot to mention:
    both 'can grow' and 'can shrink' are set to TRUE

    also, there is that .0417" space between each of the controls (with less than that I noticed that controls would print on top of each other], resulting in an unreadable mess);
    if the space could be reduced to 0", I'd be OK with that.

  4. #4
    aytee111 is offline Competent At Times
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    When you are setting the visible property, can you set the Top property at the same time?

  5. #5
    markjkubicki's Avatar
    markjkubicki is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Jul 2010
    Location
    Fire Island Pines, NY
    Posts
    496
    Quote Originally Posted by aytee111 View Post
    When you are setting the visible property, can you set the Top property at the same time?
    I could set it...
    But what would I set it to?
    Remember these stack on top of each other and each control's height will vary (from record to record)

    Possibly with code determining the height of the control(s) above and setting the top of the current control to that? Seems awkward -no?
    But maybe "the" workaround?

  6. #6
    aytee111 is offline Competent At Times
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    Time to get your calculator out!

    Is there another way of getting the data? For instance, if you had a query which showed these textboxes as separate records (maybe a UNION query), you could make this a subreport and then wouldn't have to worry about Top.

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

Similar Threads

  1. Validate textboxes before more VBA
    By cjriebe in forum Programming
    Replies: 3
    Last Post: 06-25-2014, 09:07 AM
  2. Not enough space
    By bignate in forum Queries
    Replies: 21
    Last Post: 08-20-2013, 08:59 AM
  3. Tab space
    By jamesfranklin in forum Queries
    Replies: 11
    Last Post: 11-18-2012, 08:29 PM
  4. Problem with sum of three textboxes.
    By SFC in forum Reports
    Replies: 3
    Last Post: 02-01-2012, 10:10 AM
  5. Formating Textboxes
    By desibabu90 in forum Forms
    Replies: 6
    Last Post: 08-02-2011, 07:48 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