create a blank report

I

iccsi

I need print a blank report.
All MS Access report print with data.
Are there any way to print blank report format only?

Your help is greate appreciated,
 
A

Access Developer

How much space do you want to allow where the data would normally be
displayed? Do you want to display all the Label controls that are defined?
What are you trying to accomplish with a "blank report format"? What is the
Record Source of your Report, a Table or a Query (and if the latter, pls.
describe).

(A) If you want enough space to show all the data (which seems unlikely),
you could set the Visible property of each Control that displays data to
"No" and run the Report, or

(B) If you want to show just the blank Report for a single record, do as in
(A) above, and create a TOP 1 Query for the Record Source of the Report to
extract just one Record.
 
I

iccsi

Thanks for helping,
I just wanted to print blank form for demo purpose to show our
department what our report format looks like, because the data are
confidential, so I just want to print blank form,
Thanks again,
 
A

Access Developer

I suggest you create one record of sample, not actual data, and print the
sample report using that sample data... that will give them a better idea
of how the report will actually look.

I recommend that you split your user interface and data, and use a separate
database of test data for development.

You'll find information on splitting the front end and back end at MVP Tony
Toews' site and former MVP (now on the Access team at Microsoft) Jeff
Conrad's site, both listed along with other useful references at
http://sp.ntpcug.org/accesssig/.

--
Larry Linson, Microsoft Office Access MVP
Co-author: "Microsoft Access Small Business Solutions", published by Wiley
Access newsgroup support is alive and well in USENET
comp.databases.ms-access

Thanks for helping,
I just wanted to print blank form for demo purpose to show our
department what our report format looks like, because the data are
confidential, so I just want to print blank form,
Thanks again,
 

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