K
kyle775
I have a report that sometimes has 1 record in the detail section and
sometimes it may have 10+ records. When there is not enough records
to fill the space on the page, i would like to show blank lines in
that area so after the report is printed people can add to the
section.
So for example i have this,
[Detail]
Record 1
Record 2
[footer]
and i would prefer,
[Detail]
Record 1
Record 2
________
________
________
________
[footer]
The blank lines need to grow or shrink depending on how many detail
records there are.
I have seen many posts where vertical lines are required or boxes and
grids.
my knowledge of VBA isnt extensive to the point that i could modify
those bits of code to get my result. Can anyone give me some help?
sometimes it may have 10+ records. When there is not enough records
to fill the space on the page, i would like to show blank lines in
that area so after the report is printed people can add to the
section.
So for example i have this,
[Detail]
Record 1
Record 2
[footer]
and i would prefer,
[Detail]
Record 1
Record 2
________
________
________
________
[footer]
The blank lines need to grow or shrink depending on how many detail
records there are.
I have seen many posts where vertical lines are required or boxes and
grids.
my knowledge of VBA isnt extensive to the point that i could modify
those bits of code to get my result. Can anyone give me some help?