is is possible to send an access report directly to a printer instead of the
screen first?

What is the difference between doing a report in access by using design view,
autoreport tabular, Autoreport Columnar and Report Wizard.
I am using Microsoft Access 2,003
Thank you for helping me.

I have built a report that lists transactions for an account # between
certain dates that are entered by the user.
I have a planned budget field that is the inital amt for that account.  
At the end of the report I get a balance of all my transactions for that

In the detail section of a report (Can Shrink, Cannot Grow) I have a
rich-text (ActiveX) component that varies in height according to the amount
of text that has been typed, font size etc. This is always the last item
(vertically) in the detail section. In the OnFormat event for ...

When printing a report to the screen and subsequently to the printer the
report is magnified, that is, it's like the font is changed from 12 to 72 so
that a single page report takes up 12 sheets of paper.  This is not a zoom
issue, the size of the text in the report just gets ...

I want to run a database in the background which will refresh data and print
reports say every three minutes from the time the application is started
until it is closed.
I would also like to program a delay because I have a shelled batch file in

I 've read the thread 'Report Caption' by Scott Duncan, but the solution did
not work when the document is spooled.

Access 2003 ADP
I have code where I set or unset a watermark according to certain rules.
This code is run on the "retreat" event:
Private Sub InhouseCodeGroupHeader_Retreat()

I have a db where one of the fields contains the path to a jpg file. I've got
a report that runs and in the detail section I have VB code that loads the
path into a picture control. In the event that the image file is not found I
load a NoPicture.bmp. It functions properly for ...

I would like to be able to format/change the colour of a
cells border within a report depending upon the contents
of the cell,  i cannot see how to do it
Conditionally formatting only seems to allow me to change

Is it possible to do the following......
I have a crosstab field that generates different COLUMN
Headings based on the contents of the tables it is
generating the query results from run to run.

I'm using code that I found posted here (DoCmd.Maximize) to maximize a report
when opened.  The code is connected to the reports On Open event.  I would
like to do the same for another 15 - 20 reports.  Is there a quick way to
accomplish this rather than opening each report ...

"the printer has not yet responded, but the Microsoft
office program may be able to proceed without printer
information. Do you want to continue to wait for the
printer

I have a report that is based on a table.  I use a macro to refresh the table
and print the report.  I only want to print the report if the table has data
in it.
Any ideas?

I have a report based on a table.  The field that I want to sort is a name
field based on a lookup list.  the lookup field is two columns, NameID and
Name.  My report prints out the name (not the NameID number) but it sorts the
names by the NameID number and not alphabetically by ...