How can I change the positions of controls on reports that are on preview
state ?
I want to do that, so that the new positions are saved on db (and retrieved
back on format/print events) for reports that need to be changed by the user

Hello...
Thanks for looking at this.   I run a military medical clinic and I want to
build a patient health care hand out report application.  What I would like
to do is have a custom screen, where my technicians click on check boxes

I have a report that shows a list of projects from a
project table.  The project table has a field called
category and is one to many.  A category for a project
could be transportation or it could also be energy.  I

I have a main report which contains 7 subreports. One of the subreports also
contains a subreport. When I attempt to run the report - it is very slow. The
first page appears, then when you click the next record, it takes as long to
display the next page. Any suggestions on ...

I have a field chgnum.  I want to select a different field chgamount for
certain chgnum.  My first thought was to do the following in a query and
total them in a report, i.e.  =([amt1] + [amt2])
iif chgnum = "123", chgamount, null as amt1

I have 3 subreports within my main report, each with a field containing 10
records.  I want to add the first row (first record) of each of the 3
subreports, but do not know how to reference this.
If I create a textbox and have the data source as

In the process of creating a report for our users that would occasionally
need to accomodate large text fields in the Detail Section of the report, we
now cannot get the Detail Section to shrink unless we set the Detail
section's Can Grow property to "No".  This is true even if all ...

Is there anything I can do to insure that a subreport label will always
print on the same page as it's subreport?
I'm referring to the label that appears in the upper left above the
subreport control in design view, that the wizard creates when you imbed a

i have a report with this source :
SELECT emp.ename, data.t1In, data.edate, data.t1Out, data.t2In, data.t2Out,
emp.eid, Format([edate],"mm") AS [Month]
FROM emp INNER JOIN data ON emp.eid = data.EID

how do I avoid redoing the format of a report I like over and over again
whenever I import a new database?

For example in a roport I am print sales history by Month. If a month sales
is zero I do not what zeroes to print out. I want the field to be blank or
print out spaces. (In cobol we used the format type ZZZZ.ZZ)
Thanks

Just in case, there are some who have only subscribed to this newsgroup, I
am posting my problem here.  If you have subscribed to the
microsoft.public.access also, I apologize for the duplicate posting.
Here is my problem: Does anyone know how to center a report (e.g. Sales

I have a report which prints off statements for a number of accounts, each
account starting on a new page. I want to be able to include a Page x of y
message. However it needs to be specific to each account, e.g. if 2 accounts
each printed on two pages, I want 'Page 1 of 2' and ...

I want to have a graph in a 0reports that are linked to a query.
I would like the graph to update automatically every time I send the report
to the printer.
I have tried to do a work-a-round by copying the query data sheet into the

I am opening a report via VB code, using DoCmd.OpenReport.  It works great,
but it always opens the report behind several other forms that may be open at
the time.  I would like it to be opened in front of (on top of) everything
else that's open.   All the forms and the report ...