Results 1 to 2 of 2
  1. 06-12-2014, 09:28 AM #1
    zmbaker
    zmbaker is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2014
    Posts
    31

    Hide Blank Rows


    I am looking for an expression that I can apply to a query that will hide the blank rows that contain a certain blank cell. Is this possible?
    Reply With Quote Reply With Quote
  2. 06-12-2014, 09:47 AM #2
    rpeare
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    just put

    Is not null

    in the criteria
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Hide Rows in a subreport
    By gemadan96 in forum Reports
    Replies: 5
    Last Post: 05-29-2014, 01:49 PM
  2. Hide report label when text box is null/blank
    By crsport3 in forum Access
    Replies: 7
    Last Post: 10-30-2013, 07:14 AM
  3. Hide Rows in a Report
    By alpha in forum Reports
    Replies: 2
    Last Post: 01-25-2012, 01:27 PM
  4. How to get a Report to hide a record with a blank field?
    By yes sir in forum Access
    Replies: 3
    Last Post: 09-15-2010, 01:04 PM
  5. Hiding rows when blank in a report.
    By ser01 in forum Reports
    Replies: 0
    Last Post: 02-27-2010, 10:29 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
  •  

Forum Rules

Other Forums: Microsoft Office Forums