Printing a Blank Report

[Guest]

I've seen in some posts that people are wondering "why would you want to
pront out a blank report?". Well sometime you need a sign in sheet, or just a
fill in the blank sheet. I couldn't make a blank form so now I did a save as
and made my form into report. Now I want to print a "blank" report. Does
anyone know how to make Access print a blank report? Knowing my stupidity it
is probably something easy but I just can't find it. Thanks in advance.

 

[Rick B]

I would use Word or Excel to produce a sheet designed for folks to write in.
If you use the same report you normally print, are you going to have room to
write? If you space it large enough to write, how much paper will you waste
when you print it? I've tried to fill in pages before that were tiny and it
is not very professional.

Also, the printed report will include data, but the sign-up will need lines
or squares to write in. I can't picture a report that would print out well
that could be used as a hand-written form as well.

I'd build my manual sign-up sheets as a separate document in Word or Excel.
You could do it in Access, but if you want to provide space and lines upon
which to write, you will need to do it as a separate report from the one you
normally print.

 

[Guest]

You can send a filter to the report, with a value that doesn't exist in the
table

Dim MyFilter
MyFilter = "[KeyField] = Null"
Docmd.OpenReport "ReporName" , , , MyFilter

 

[Guest]

Place the data you want to see in labels and the boxes, etc. as text boxes or
lines.
No data sources for any of the controls. the boxes should have a border that
shows.
It should print all the labels and fill-in the blanks with no trouble.

HTH
scruffy

 

[Allen Browne]

As you found, this is not as simple as it sounds.

You can print a report with no records. The labels print, and the blank text
boxes (assuming their borders are set), but there are difficulties.

First thing is that calculated controls result in #Error. Use the HasData
property of the report to avoid this. For example, if you have:
=[FirstName] & " " & [Surname]
you will need to replace it with:
=IIf([Report].[HasData], [FirstName] & " " & [Surname], Null)

If you have VBA function calls, you will need to make sure that the
functions accept Variants for all arguments and returns a Variant. Test if
each argument IsError(), and return a suitable value (such as Null) if it
is.

Another issue is that any subreports don't print at all.

Naturally, you don't cancel the NoData event of the report either.