I would like to create a report that has varying length dots between two
fields.  For example:
 Jim . . . . . . . . jim@somecompany.com
 Frederick. . . . . . . . . . . Fred@aol.com

Actually, what I need is to ask  how can I build a report allowing for
the Dynamically building and Naming and swapping out of columns with their
header labels as they contain no values for those with values. Of course,
there will come a time when all columns will have a value, ...

Why doesn't the dash in the 9 digit postal code print out on paper?

Access 2003 with Win XP Pro.
There are several reports in one of my databases that has problems printing.
If I  
print to my Tektronix color laser, the top line of the page says, "Error:

Hi Duane
I have replied to your response and also here to thank you
for taking the time to reply. (original message below)
I am happy to report that the coding I mentioned had

Access 2003 won't let me generate reports, waht do I do?

I have a client who decided to upgrade to Office 2003. The application
I wrote is in MS Access 2K (MDE file) and everything functions well in
his new Office 2003 environment except two reports. I can run the
reports on my development machine (Windows 2K, Office 2K) and all is

I am trying to use the report wizard to create a new report, as I have done
many times before, and the error message "ActiveX component cannot create
object" comes up.  I have repaired the database, repaired Office 2003,
reinstalled Office 2003, checked and installed updates, and ...

1) I've put some labels and textboxes on page foot, when preview or print,
these
labels become very large, almost 5 time larger than they shold be. Is it
forbidden to put labels on page foot?

I have code that prepares a report to be printed. At the end of the code the
report is presented in preview mode and the user can print the report using
the print menu. When the user closes the report the msgBox appears to ask if
the report should be saved. I would like to ...

Hi,
I am trying to calculate the sum of values for the records on each page of
the report in the page footer. It seems like cannot be done. Is there a
work-aournd?

Hi
This is a repost - I have just brought it to the front in
the hope that someone new has had a similar problem and
solved it.

I have a form built with 5 drop-down selections for different things to
filter a report.  I need a user to be able to select one of these items and
run the report, or be able to select 2 or 3 or 4 or 5 of the items and run
the report.  Right now I only have it coded for the each ...

I have a report with 8 subreports Each subreport alculates totals of a
certain field. I need to make a final calculation on the main report at the
end with the previously "calculated fields" from subreports.
Any idea of how to do it ? thanks for your help.