Results 1 to 6 of 6
  1. #1
    Pam Buckner is offline Novice
    Windows XP Access 2007
    Join Date
    Mar 2010
    Posts
    12

    Getting Rid of Empty Space

    I've created a report containing a field which may not have information to display on the report once a query is run. This field has no other fields to the right or left of it, therefore the printed report shows a blank space between records. I would like to know how I can fill up this "empty" space with information from the next record. I've spent hours working with macros, expressions and code trying to do this ... it really can't be that hard, right?

  2. #2
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,043
    Rather than trying to hide it, the "normal" solution would be to eliminate those records in the source query. Is that not an option?
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    Pam Buckner is offline Novice
    Windows XP Access 2007
    Join Date
    Mar 2010
    Posts
    12
    The report is simply a contact list with phone numbers to include a field for mobile phones. The contact list needs to contain all records from the query, and many of those individuals do not have mobile phones. The mobile phone field sits directly below the phone field - all by itself (I know I could redesign, right?) - when it's empty, there's a blank line in between indvidual contact information.

    In other database programs, i.e. FileMaker Pro, there's a simple check box for the section which deletes any blank space between records. This is the solution I'm looking for.

    Thanks for your reply.

  4. #4
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,043
    Ah, you said "between records" which implied it was a separate record (which a case could be made for). It sounds like the phone numbers are fields within the same record. Try making the textbox for it really tiny vertically, then set the textbox and section's Can Grow properties to Yes.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  5. #5
    Pam Buckner is offline Novice
    Windows XP Access 2007
    Join Date
    Mar 2010
    Posts
    12
    Yes, you are correct.

    Hey! That worked. I knew it was something simple. Thanks so much!

  6. #6
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,043
    Glad it worked for you, and welcome to the site by the way!
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Go to first empty record
    By westcoastbmx in forum Forms
    Replies: 2
    Last Post: 10-30-2009, 01:37 PM
  2. Empty Lookup
    By mikel in forum Access
    Replies: 39
    Last Post: 08-07-2009, 01:00 PM
  3. Space Between Header and Detail in Report
    By tigers in forum Reports
    Replies: 3
    Last Post: 06-23-2009, 12:01 AM
  4. Error 28: Out of Stack Space??
    By mugsmugs in forum Access
    Replies: 1
    Last Post: 02-22-2009, 09:54 AM
  5. Export to RTF is creating white space at end of page
    By Sherri726 in forum Import/Export Data
    Replies: 0
    Last Post: 12-19-2006, 03:24 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