Looking for help with a color setting on a report.
I'm designing a report in which the background & foreground colors for a
single control need to change based on a database / query produced value.
Each record in the query contains the background & foreground numbers that I

Hi, I have a report without Record Source which contains several subreports
and two rows of unbound text boxes in the detail section (text boxes a
situated beneath the subreports). It works fine except that when one row of
unbound boxes get on bottom of a page they are cut in the ...

is there any way to change the positions (left.coordinate) and width of
textfields with vba while opening a report?
Problem: i have 10 textfields and the user can decide, how many of them
should be printed. so they can say: print column 1,2,5,6 or 3,6,8 or

I have lengthy report that is grouped by Zone ID.  I want to e-mail the zone
supervisor the pages of this report  as an attachment (in a snapshot format)
that deal with just their zone.  currently we e-mail the whole report and the
hunt for their information.  The zone supervisor ...

I have an Access2003 report with an embedded PDF file, and I'm running
into the problem where only the first page of the PDF shows up in my
report.
My question is a two-parter:

I've encountered a most interesting anomaly
in A2003 Reports. I have a report containing
two columns. The Detail_Format event is triggered
twice at the beginning of each column. And,

New to the group.
Have been struggling with the following problem for a while.
Wish to prepare a customer statement covering transactions (charges
and payments) for a selected time period (RPTstart) and (RPTend)

I have created a report in Access, and want to change the report heading.  
How do I do that?

I am trying to create a graph in ACCESS that will continue a trend line even
if there is not data at a data point.  For instance:
    Sig 1    Sig 2    Sig 3
1    1    1    1   

Anyone can help in creating this join in designer?

A seemingly simple formula is giving me an #Error message.  Here's the info.
1) The field on the report uses information from a query field named Dent1.
When the query is run by itself, the value it provides is 11.45.
2) When I create a field box in the report with only "=Dent1", ...

I have a conditional formatting expression i would like to convert to code,
and need some help!
I want the code to be in the OnOpen event of a report (called
rptAllInformation).

I am trying to use the same report layout for multiple queries but am having
some trouble.  The button code is:
Private Sub cmdOpenProjectReport_Click()
On Error GoTo Err_cmdOpenProjectReport_Click

Sorry if this has been answered elsewhere, I have checked and cannot find
what i am looking for.
I want to have a report that I can use for name labels at a conference, I
can set up the report to do the labels but I would like to also have the logo

I have a report with subreports in it. When one of the subreports is empty I
would like to have a standard phrase show up such as "There are no additons
today". I am using Access 2003.
Is this possible?