Results 1 to 3 of 3
  1. #1
    Israel is offline Novice
    Windows XP Access 2003
    Join Date
    Aug 2014
    Posts
    2

    How do I eliminate line spaces on a report that has multiple fields?

    I have created a report with multiple fields to create a roster. The roster shows "Organization Name", "First name", "Last Name, "Address" etc.

    I have figured out how to eliminate spaces between some of the fields. For example, there are no longer spaces between first name and last name. I have not, however, figured out how to eliminate a whole line between the different fields, when no space is needed.

    For example. Instead of:

    Line 1 Lopez Ramirez Roofing, Inc.
    Line 2
    Line 3 Rogelio Lopez
    Line 4 Address....



    I would like to see:

    Line 1 Lopez Ramirez Roofing, Inc.
    Line 2 Rogelio Lopez
    Line 3 Address...

    Any thoughts?

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,624
    Might have some luck with sizing the textbox height to as small as possible (0) and then set the CanGrow property to yes.

    I know I've dealt with this question before but finding the thread could be a challenge.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    Israel is offline Novice
    Windows XP Access 2003
    Join Date
    Aug 2014
    Posts
    2
    You. Are. Absolutely. Awesome.

    Thank you, thank you, and thank you some more.

    I've been working on this for hours and hours.

    May your God shower you with blessings for the rest of your days.

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

Similar Threads

  1. Replies: 8
    Last Post: 01-30-2014, 01:43 PM
  2. Replies: 2
    Last Post: 11-11-2013, 10:09 AM
  3. Eliminate line breaks in exported report
    By thekruser in forum Reports
    Replies: 3
    Last Post: 09-28-2010, 08:57 PM
  4. Line Spaces in Sql View
    By Matthieu in forum Access
    Replies: 1
    Last Post: 04-06-2010, 10:24 AM
  5. Replies: 0
    Last Post: 11-23-2009, 09:19 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