Results 1 to 3 of 3
  1. #1
    darkdemon is offline Novice
    Windows 10 Access 2016
    Join Date
    Oct 2020

    Blank lines in a report


    I have a new problem. I have a form (frmDE) that has its field where I input the data, which goes into a query (qryDE) and stored on a table (tblDE). Now comes the problem on my report (rptDE), how do I automatically insert a blank line in the report if a new date is started on the form?

    So basically on my form, I input lets just say 3 Nov 2020, 4 Nov 2020, and 5 Nov 2020. Then when I print preview the report I would like to have it show the following:

    3 Nov 2020
    -blank line here-
    4 Nov 2020
    -blank line here-
    5 Nov 2020


    Any ideas? I have scoured everything I can and I am thinking it will come down to something in conditional formatting, but I do not know how to write the expression, unless I am entirely in the wrong ballpark.

    Anyway thank you in advance.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Make a footer in the date field group.
    make the gap as big as you want.

  3. #3
    darkdemon is offline Novice
    Windows 10 Access 2016
    Join Date
    Oct 2020
    Thank you. It helped with that aspect.

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

Similar Threads

  1. Replies: 1
    Last Post: 12-01-2014, 10:39 AM
  2. Replies: 17
    Last Post: 06-25-2013, 05:06 PM
  3. Replies: 5
    Last Post: 06-13-2013, 11:23 AM
  4. Eliminating blank lines when printing labels
    By tomcoll in forum Reports
    Replies: 12
    Last Post: 11-16-2011, 07:50 PM
  5. Report printing unknown blank lines.
    By dgrzalja in forum Reports
    Replies: 10
    Last Post: 11-02-2009, 12:21 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 - Senior Forums