adding empty rows to the end of a report

[grlgeek]

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?

[David Mann]

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" <[e-mail]> 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?

[PC Datasheet]

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" <[e-mail]> 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?

[grlgeek]

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" <[e-mail]> 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?