How can I get an Unbound Object (parameter prompt) to
print in the Report Header when there is no data that is
output to the report? Example: Looking for items with code
730 and there are none. I want the 730 to show in the

I have created a report where, depending upon the data,
the backcolor of the fields for a record changes.
When the enrollment for a school is less than the school's
building capacity, the backcolor for all the fields for

I have run into a report situation that I don't know how to solve.  I am
hoping someone has a suggestion.
I am running a crosstab query that I want to publish in a report.  The
underlying table relates to registrations on a monthly event basis, so this

I have a table with among other things has first-name,
last-name, and orgainzation.  Some records only data in
the orgainzation field, some only have data in the last-
name field, some only have data in the first-name field,

I am the same guy who is having trouble with printing
textbox on the last new page of report. If you can see my
last two posting both with Print heading you will get what
the issue is. Also i tried the force new page property but

On Nodata event, after I run a message saying there is no
data for the specified range, I use docmd.cancelEvent to
cancel the report opening.  A message comes up saying "The
OpenReport Action was cancelled".

I have a report that groups by merchant and then by
store.  If one of the stores has no data, it drops off
the report.  I'd prefer to have the report show all
values even if they are zero.  If the whole report had no

I want to print a textBox(memo) which comes from a table
after user enter data through form. The issue is that i
want to print it at the end of every report. I have very
complex report. In one report there are several

Newbie question here on reporting. I have a report that
displays times. What I'm trying to do this:
If fieldA = "Noon" then
   if time <= 11:45:00 AM <BOLD>

I would like to print out a report with people's names,
but they are in 2 columns.  I would like 1 column on the
report so that I can center it on the paper better.  
Here's what I have:

I have a form for daily production data entry.It is laid
out  well for data entry but, not for printing. I created a
report with same information for printing. I would like to
put a command button on form to print the report. How can I

Sir,
I create a customer account statemnt report in Access.
There is no transaction for some customers in certain
period. So I am getiing #Err# in sum function. Instead of

Dear Sirs,
I have following query for report preparation in Access:
How to get the report in format, with records appearing in
multiple rows, e.g.

I have a button on a form that opens a report and shows only the data for the
record I am currently viewing.  When I print this report I would like also
for a word file to be printed.
If that can't happen then I would like to add a second page to my report

I've set up a report using the defaults in Access 2002.  I
initially set it up in portrait.  I changed
the page layout to landscape.  But when I try to enlarge
the page greater than 8inches, I get an error