print report without data

I

iccsi

I would like to print my report as a template without data.
I have a report and would like print just a blank report without data
in it.

Is it possible?

If yes, how can I do it?

Your help is great appreciated,
 
M

Marshall Barton

iccsi said:
I would like to print my report as a template without data.
I have a report and would like print just a blank report without data
in it.

Is it possible?

If yes, how can I do it?


Many things are possible. The question is what kind of
hoops you're willing to jump through to do it.

I think the easiest way could be to add a record with Null
on all fields except it primary key field. Then print the
report with a filter that selects just that one record.

If that's not acceptable, then I think you'll need to change
the report's record source to a query that retrieves a
single record with all fields being Null from any table:

SELECT DISTINCT Null As myfirstfield, Null As mysecondfield,
....
FROM [any small table]
 
D

David-W-Fenton

iccsi said:
I would like to print my report as a template without data.
I have a report and would like print just a blank report without
data in it.

Is it possible?

If yes, how can I do it?

Many things are possible. The question is what kind of
hoops you're willing to jump through to do it.

I think the easiest way could be to add a record with Null
on all fields except it primary key field. Then print the
report with a filter that selects just that one record.

If that's not acceptable, then I think you'll need to change
the report's record source to a query that retrieves a
single record with all fields being Null from any table:

SELECT DISTINCT Null As myfirstfield, Null As mysecondfield,
...
FROM [any small table]

My question is how often this needs to be done. If it's a one off,
there's any number of ways of doing it.

If you need to do it frequently, then I'd suggest writing code to
change the color of the detail fields to white and print any old
random page. You could probably do that with walking the controls
collection and setting the foreground color to white for all
textboxes that have a ControlSource. Of course, if you have any
textboxes with a ControlSource set that you want displaying on the
form, you'll have to make an exception for that one, but that's
pretty easily done.
 

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

Top