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?
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
