I call a preview of my report from within a form with the use of acpreview
option.
The report appears with default preview option "fit" which is very small.
How can I make it automatically apear larger or at least make the containing

I have a report that looks back at the previous 20 years of data and prints
the values and the % change from the previous year.  All the data, including
the % change are contained in a table (not my doing).  I have written some
code (see below) to not display the percent change of ...

I have an Access Report that I am trying to export to an Excel Spreadsheet so
I can create Charts and Graphs. My problem is when the data is exported and
the Spreadsheet opens, there is no data. I am using Access 2000 and Office
2003. Is this a problem? I feel my Report is pretty ...

In Crystal reports, you can set a property on a footer section to
overlap the section above.
With this featrue, you could do the following:
You could have a count in a group footer section aligned vertically

I followed the Duane Hookom's directions for setting up a concatenate
function in my database.  As far as I can tell it's all set up correctly...
I copied the basConcatenate function over to my database and in my query I'm
using the VBA code:

I sent this post on 11/30/06 and no one has responded.  Is this too
complicated a question?
If not here is my question reposted.
Hi Access Guru's,

I have a database which records Presentations based on PresentationDate
as a date in format DDMMYYYY and PresentationSemester (Spring, Summer,
Fall).  I need my report to display the number of presentations done
for each semester in each year.  Is this possible in access?  I have

I hope I can get an answer to this one because it has been driving me
crazy.
I have 3 reports in Access 2003 that when printed make up a booklet.
A table of contents is produced from the first report to be printed,

A report only takes up half an 8.5 by 11 page.  My report has umpteen pages.
I want to print two of the Access pages on one physical paper page.  I feel
that I ought to know how to do this, but....
Thank you in advance,

I have set up a database that analyses the effectiveness of production lines.
For my report, users select a Start Date and End date (through a form) and
the enter button brings up the report. The first page (first production line)
displays the start and end date however any other ...

I have dowloaded and imported the generic concatenate function into my
application from
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.
I have a report that I filter by date range and customer name and get

I have a report that has 20 textboxes with labels.  Not all textboxes have
data.  I set the "can shrink" to "yes" and it supresses the textboxes but I
still see the labels.  
How do I supress the labels?

I have a report with a label. I think I must have made a typo in it (I
was trying to refer to a datafield), but this must have been a lethal
typo: When I try to go to Preview or Design View, Access crashes. Every
time. Has anyone out there experienced this before, or have an idea ...

Thanks again for all the help this group has provided !  Simply
amazing.
  I have a database that I use to create a "class listing" each month,
works pretty good,  I am trying to enhance it.   On the form I use to

I have a report that I am forcing the labels, frames, textboxes etc to be
printed on at the bottom of the last page of the report.
The code below does just that (ie all objects have their visibility turned
to false to start by default but turned to true if the current page equals