Hi. I was warned about line wrapping and sure enough!  My
report is landscape and I want the gray shading to go
across the entire page, so I used method 1:
Private Sub Detail_Format(Cancel As Integer, FormatCount

On the Northwind database if you open “Sales Reports Dialog” Form and select
only the button “Sales by Category” to print all categories, you still get
BEVERAGES on the title of the Report. Is there any way to remove this title
when we print the report for all categories (because ...

I have a report based on a query that I want to use as a template (because
I'm lazy and don't want to lay it all out again).  I thought I'd be smart
and just change the query name in the Report's 'record source' for each
successive report.  My problem is that when I run the  I run ...

Access 2002 user.  I have a report menu switchboard with about 10 different
command buttons to preview a variety of reports.
Is it possible to put a command button on the report that will alter the
SORT order of the report in the 2nd (or sometimes 3rd) grouping level?

I have a report with a text box that I would like to display information
from an open form.
The form has a Combo Box with a value Me.CCID.Column(1) that I would like
to show.

I am fairly inexprienced with Access, and am trying to calculate one column
on my report.  I have created the text box, and put "=Sum([#BUNCHES])", as
help has told me to, however, on the report I get "Error", instead of the
total.  What am I doing wrong?

I have a report, based on a query.  In the report I have a calculation in an
unbound textbox where I multiply the Standard Cost by the Safety Stock
quantity of a number of items in order to get the value of each item.
The control source for the equation reads as   ...

I have a query (Query1) that pulls some records from a table, something
like:
   SELECT [ID],[REF
ID],[Table1].[field1],[Table1].[field2],[Table2].[field1]

I have a report which opens a parameter query. If the query is returning 0
(zero) rows, there should be a message saying "no rows returned" and then
the empty report should not open, I mean nothing should happen after that.
In the report, I went to "ON NO DATA" and I wrote:

Is it possible to include more than one record source in one report? I would
like a report that includes two fields that are based on fields from two
different queries, but it's not working. Is it possible?
Thanx,

I am opening upto three reports based on criteria in a form control. The
form is popup, modal, dialogue. When the user clicks a command button to
open the reports the forms visible property is set to false to hide the
form, this allows the report queries to get data from a form ...

I am dealing with sermons.  If the sermons are part of a series, they have a
unique series code. ("PS2" for instance).   For the sermons which are not
part of a series, I want to have a miscellaneous series code and group them
together by the way they are stored.  I was thinking ...

i know that black is vbblack
when i want to set colours, and red is vbred
but how do i get shades of grey????

I have a need for 6 columns, the first a side bar header type column, and the
next 5 data columns.  I have the columns set up and displaying the
information correctly.  What I would like to do so make the 5 data columns
smaller then the "side bar" column.  Any ideas?

I have a very serious problem. I created a report (normal report, no special
effects).
There is a header area - where the labels for the colums are. and edit boxes
in the detail area.