Results 1 to 3 of 3
  1. #1
    nishant.dhruve is offline Advanced Beginner
    Windows 7 64bit Access 2013 64bit
    Join Date
    Aug 2016
    Posts
    34

    need help on hiding empty space on report


    Click image for larger version. 

Name:	hide.PNG 
Views:	5 
Size:	17.0 KB 
ID:	25503
    i want to hide all the rows which dont have dates on it within the report its has been created.
    How i can i do this?/

  2. #2
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    set the criteria of you query driving this to exclude items with no date

    in other words put:

    is not null

    in the appropriate date field in the query driving this form/report

  3. #3
    nishant.dhruve is offline Advanced Beginner
    Windows 7 64bit Access 2013 64bit
    Join Date
    Aug 2016
    Posts
    34
    Thank you for your help
    it worked

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

Similar Threads

  1. Need less than a full space in report.
    By BatmanMR287 in forum Reports
    Replies: 3
    Last Post: 10-13-2015, 07:28 PM
  2. empty space start combo
    By sergran in forum Programming
    Replies: 30
    Last Post: 09-24-2013, 10:38 AM
  3. Hiding an Empty Sub-report
    By ophirw in forum Reports
    Replies: 16
    Last Post: 10-04-2011, 09:37 AM
  4. Getting Rid of Empty Space
    By Pam Buckner in forum Database Design
    Replies: 5
    Last Post: 03-05-2010, 05:46 PM
  5. Hiding fields that contains empty records
    By sakthivels in forum Reports
    Replies: 4
    Last Post: 05-27-2009, 07:06 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