If there are more than one page of a report, how do I print for example,
"Cost Summary Continued on next page" on the first page?
Also, I have a line to separate two sections on the report, when there is a
second page, I want to make this line invisible on the first page.

I have a visual basic application which opens an access report based on input
parameters. The following code is being used for the same:
dbpath = DATABASE_PATH
Set Acc = CreateObject("Access.Application")

Each week we send out a request for files using data contained in a database
on our warehouse load.  The report is based on a query using this data.  
Problem:  the detail section of the report needs to be the same size (15
lines) whether there is one file as a result of the query ...

I have an addr1 and addr2 field.  When the addr2 field is blank, it is
leaving an unnecessary space before the city and state.  Is there a way to
tell access that if the field is blank to ignor so that no extra space is
appearing?

On my report, I have 4 unbound checkboxes. But I would like to have them
either be checked (true) or unchecked (false) based on data entered in
specific text fields.
What I mean is checkbox #1 is either checked or unchecked based on a text

How do I omit a field on a report only when it is a null value?

I have a form using an Option Group box that calls the same report and
displays the records that the user has chosen.  I have 4 choices for them to
choose from and then the report is displayed filtered with the records that
they chose.  What I want to do is have the report title ...

ok i have a report and my boss wants to see all the
records on this report but he would like to be able to
like highlight the report to show the ones he already
reviewed    is there some way to highlight these   like in

After a long term illness I am revisiting reports built in
Access 2000.
I have built up a report which uses a sub report
containing a cross tab query to allow for a variable

On submitting a question I ususally  get an error message that says my post
failed and operations has been notified. The question disappears when it
doesn't go through, and then you have to type it all over again. I have not
been able ta get a question through to  Access/Reports ...

Hi ! , I have a graph on a form that can change dynamically depending on
user's choice (data, chart type) This part is working good. I tried to
replicate the graph on the form in the report in vba but it's useless (can
not access the control property in report )   Is there a way ...

how do I print odd pages of a report automatically?

I am trying to send out Access Reports through the
snapshot format.  Some people can receive while others
cannot.  Do people need to have MS Access on their PCs in
order to read this format?  What are the requirements for

I've created a query (to create a report) that pulls a variety of
"descriptions" (construction types).
I'm using the following expression to count the number of times a particular
description is returned from a query.  In this case, the description type is

In a schema.ini file, is it possible to specify NumberDigits on a per column
basis.
My table has a number of numeric columns, I want to be able to specify some
as 2 decimal places, others as 4 decimal places.