line breaks in reports

B

binny

Is it possible to put line breaks in a report?
I have a full page of records (all the same group) and they are hard to
read.Is there some way I can put in a line break every 5 records or so?
 
F

fredg

Is it possible to put line breaks in a report?
I have a full page of records (all the same group) and they are hard to
read.Is there some way I can put in a line break every 5 records or so?
Click to expand...

By a 'Line Break' do you mean a space between every 5th line?

Add an unbound text control to the detail section.
Set it's ControlSource to:
=1
Set it's Running Sum property to Over All
Size the height of the control to whatever space you wish to have
between lines.
Name this control 'CountRecords'
You can make it not visible if you don't want to show the count.

Add an unbound control to the bottom of the Detail Section.
Set it's control source to:
= " "
Set it's Can Shrink property to Yes.
*** Make sure there is no other control on this same row. ***

Set the Detail Section's Can Shrink property to Yes

Code the Detail Section's Format Event:
Me![ControlName].Visible = Me![CountRecords] Mod 5 = 0
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Exporting to CSV with embedded line breaks 1
Unwanted paragraph breaks when pasting text 5
Excel Concatenate addresses in Excel but avoiding blanks, and line breaks 6
Outlook Outlook 2013: How to print the task list so that it shows the notes on multiple lines if needed 0
Line Breaks in Linked Table 0
Excel Replace with line break (Excel for Mac) 0
Avoid page breaks on report 1
Line breaks in Excel 2

Top