I have developed what is (for me) a fairly complex report, with a number of
fields that are not visible, but are necessary to the report's functioning,
and some programming On Print and On Formatting.  Depending on the data, the
report looks different.  

I have a sub query that is the underlying input for a sub report imbedded in
the main body of a report.  The query itself returns data that has multiple
instances of some fields, (ie duplicate value for some fields in a record but
not all fields).

Im trying to create an invoice using my reports. Its all great but when
there is only a couple of items on the table is really small and looks
stupid, im tring to find a way of having a full page table and the report
filling it down as much as it can. anyone got any ideas?

Is it possible to print only the first page of a report?
Mattias

I have a main report with multiple instances of a particular subreport in
it, with unique control names of course. Is there a way to determine the
corresponding subreport control in the main report while executing the
Report_Open procedure of the subreport? I would like to ...

I have a report which has a landscape view and margins on all four sides of
the report set to .5 inches. The problem is that these settings seem to
become nullified every once and a while. I do not want employees to have to
reset these settings every time it happens. With some ...

Hi I use the following code to pull off  6 reports, with "Between [Enter The
Start Date] And [Enter The Finish Date]" in the query date field of each
report qry.  It all works but is it possible to set it up in some way so
that the start and finish dates only have to be input ...

I have two pivot tables feed off from the same Access query. One is in Excel
workbook, another is in data access page. There is some data discrepancy
exists between them. How come? I really run out of idea what could cause the
problem.

I have a report that will generate barcodes for each of 2 fields. If either,
or both, fields are blank I get an "invalid null" message when running the
report. How can I eliminate these invalid null messages when running the
report? The two fields are NonStockBarcode, and ...

I have several rectangles I use in a report to outline column headers (for a
crosstab query report).  For some reason, one of the rectangles has the top
line and half the left side missing.  I've checked all the property settings
and they are identical to that of the other ...

I have a report based on a crosstab query, with the number of columns on the
report depending on what the user inputs into a related form.
There are instances where the total no. of columns will not fit on the width
of the page ( I already have the page set up on horizontal ...

Is the a way to create a report with a calendar monthly view?
I have a calendar form that I made and I am wanting to print a calendar from
that. In my form I am using a big grid that looks like a calendar you would
buy from a store. and in each box I have a listbox(42 listboxes to ...

I am creating a duplicates report and I would like to put a lline or a space
between the sets of duplicates. It would read easier like this:
John Smith
John Smith

I am creating a duplicates report and want to insert a line or double space
between sets of duplicates. How would I do that? So it will print out easier
to read, like this:
John Smith

I want to insert a "Continued on Next Page" message when there is more than
one page to a report.  I'm using the following code and it isn't working.  
Any suggestions?
Private Sub PageHeaderSection_Format(Cancel As Integer, FormatCount As