I am going crazy with this text box.  I want it to insert a CR/LF only when
the line has text, but it does it every time.  Why?  I need help!
=[DonName] & Chr(13) & Chr(10) &
IIf(IsNull([DonAddr1]),"",[DonAddr1] & Chr(13) & Chr(10)) &

I'm producing packing lists per order for my supplier, and would like to
integrate the invoices as part of the report output. Invoices are saved
as pdf-documents (done outside MS-Access) and named as
C:invoices\order_id.pdf, for instance C:\invoices\6478.pdf. So to make

I'm creating a report which originally has 10 fields in details. But it ends
up with too many fields defined since lots of summary are needed. What I did
is split the report into two reports, one with details and group summary and
the other with details invisible and grand totals ...

Is there a way of stopping the printing of the page headers on the page that
has the report footer. The report footer appears on the last  page by
itself.
Any help greatly appreciated.

I need to print a report  without preview it by user.
How to this programmatically?
Thanks,
GB

Hi all,
My questions is how do you update a report (show all the fields that have
been entered into a form) before the record has been saved?
I have set up a report that takes information from a form. When the user has

I am using Access 2002 and I need some help.  I am using 3 tables in my
query, which my report pick up from.  Table one call Inventory contains the
following fields: "Insured Name", "FP", "CO","Rev","Ck","Dis","ReviewerID".
The fields "FP", "CO","Rev","Ck","Dis" are auditorsID ...

I posted this previously but the resolution didn't work and was rather
complicated. I'm wondering if there's a more simple approach.
I have a parameter query in a subreport that works fine. However, when I add
this subreport to the main report and execute it the parameter query ...

I've created a report in Access that is essentially a directory, listing
names & addresses, along with other information. This report is working fine
for me; my problem is that I now want to create an index that shows me the
page number that each listing is on. I have page number ...

Does anyone know how to change the names of the categories that appear in the
legend. I don't want them to say Sum of Xxxx or Count of Xxxx. I'm using
Access 2002.
Thanks,

Prior to creating a REPORT in Design or Wizard, I receive an message: You do
not have exclusive use of the database at this time etc.  When I click on OK,
the Wizard is enabled and I can go thru all the motions.  When I clik on
FINISH, I receive an window that states that WIZARD ...

I have a form that collects a string and a number, I want to print a page of
avery labels , the exact qty as collected in my form. How can I teel the
report to do that?

i have many reports in my db . what i need is after i preview and on close of
report i want to get a message to prompt me whether i want to output to file
or not .and in case i choose yes i want it to be save as snapshot format .any
body can help with this?

I have a table [private] with fields [fee] (currency), [date_received] and
[date_banked] (amoung others). Is it possible to produce a report that
would
list each record once if a [date_received] value has been entered, and

What is the syntax to send mulitple copies of a report to the printer.
Example or sample ?
I am using a HP Laser 4200 printer.
Thank You.