469,580 Members | 1,889 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,580 developers. It's quick & easy.

adding empty rows to the end of a report

I have a report for creating the switchboard labels for our phone system
receptionist switchboard. The template has 12 records per column.

I setup a report that will create the labels and put a dotted line around
them so the receptionist can easily cut them out. The report is setup with
columns so that 6 columns fit across a page. 12 records per column, 6
columns across a page, each record has a dotted line around the box.

The problem comes at the end of the report when the last column only has 3
or 4 records in it, therefore it only prints part of a column.

Trying to use the report footer doesn't work, as that wants to put it across
an entire page.

Is there a way to get the report to fill in the "x" number rows it takes to
complete the column?
Nov 13 '05 #1
3 3520
You could make all the borders transparent on the the boxes on the form.

Now, to get dotted borders, you could use dotted horizontal and vertical
lines.

This will give you a nice grid of dotted lines, whether or not there is any
data.

David

"grlgeek" <no@noway.com> wrote in message
news:P7********************@comcast.com...
I have a report for creating the switchboard labels for our phone system
receptionist switchboard. The template has 12 records per column.

I setup a report that will create the labels and put a dotted line around
them so the receptionist can easily cut them out. The report is setup with columns so that 6 columns fit across a page. 12 records per column, 6
columns across a page, each record has a dotted line around the box.

The problem comes at the end of the report when the last column only has 3
or 4 records in it, therefore it only prints part of a column.

Trying to use the report footer doesn't work, as that wants to put it across an entire page.

Is there a way to get the report to fill in the "x" number rows it takes to complete the column?

Nov 13 '05 #2
Create a duplicate table of the one you get your data from. Add some blank
records. Create a union query of your data table and this table so that the
blank records appear at the end of the results. Base your report on the
union query. The blank records at the end of the recordset will cause the
dotted lines to be printed.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"grlgeek" <no@noway.com> wrote in message
news:P7********************@comcast.com...
I have a report for creating the switchboard labels for our phone system
receptionist switchboard. The template has 12 records per column.

I setup a report that will create the labels and put a dotted line around
them so the receptionist can easily cut them out. The report is setup
with
columns so that 6 columns fit across a page. 12 records per column, 6
columns across a page, each record has a dotted line around the box.

The problem comes at the end of the report when the last column only has 3
or 4 records in it, therefore it only prints part of a column.

Trying to use the report footer doesn't work, as that wants to put it
across
an entire page.

Is there a way to get the report to fill in the "x" number rows it takes
to
complete the column?

Nov 13 '05 #3
DUH - thanks...
"PC Datasheet" <no****@nospam.spam> wrote in message
news:QT*****************@newsread2.news.atl.earthl ink.net...
Create a duplicate table of the one you get your data from. Add some blank
records. Create a union query of your data table and this table so that the blank records appear at the end of the results. Base your report on the
union query. The blank records at the end of the recordset will cause the
dotted lines to be printed.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"grlgeek" <no@noway.com> wrote in message
news:P7********************@comcast.com...
I have a report for creating the switchboard labels for our phone system
receptionist switchboard. The template has 12 records per column.

I setup a report that will create the labels and put a dotted line around them so the receptionist can easily cut them out. The report is setup
with
columns so that 6 columns fit across a page. 12 records per column, 6
columns across a page, each record has a dotted line around the box.

The problem comes at the end of the report when the last column only has 3 or 4 records in it, therefore it only prints part of a column.

Trying to use the report footer doesn't work, as that wants to put it
across
an entire page.

Is there a way to get the report to fill in the "x" number rows it takes
to
complete the column?


Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by terragrub | last post: by
reply views Thread by news.microsoft.com | last post: by
3 posts views Thread by Baren | last post: by
code green
2 posts views Thread by code green | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.