print report without data

  • Thread starter Thread starter iccsi
  • Start date Start date
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,
 
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?
Click to expand...

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]
Click to expand...

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.
 
Back
Top