Hi to All,
Is it possible to programmatically set the position of a control on a
report, I need a control (text box) to either to move up or down depending
on a criteria of another control.

I have a report with a sub report in the detail section. A value in the
detail section is aimed to tell how many records the sub report returns. I
would like to write the sub reports Record Source in the main report and send
it by code to the sub report (SELECT TOP # Product, ...

Is it possible to use data in the labels with an Access report?  For
instance, I have a report that the heading says, "Weekly Expense Reporting
for", would it be possible to add some data to this string to make it,
"Weekly Expense Reporting for & CliFName + " " CliLName".  And ...

Would it be possible if anyone could tell me whether in Access you are able to produce e.g 20 seperate reports from running a query or a macro in Access.  For example, i have a table with five different subjects how would i be able to create five seperate reports with a specific ...

Im not sure if im asking this correctly so i hope it makes sense !
In a report footer (one of several in the report), i have the following text
boxes with the expression =Sum(IIf([PREGNANCY OUTCOME]='NEGATIVE URINE
TEST',1,Null)), to give a total number for that specified ...

Hi. I want to have a reports subreport appear only if a
certain field in the subreport has some text content. Can
anyone suggest what the On Format code would look like?
Assume the names are as follows.

I have Access2000 with WindowsXP
I have an address system to be printed out where one name can be associated
with another name, i.e. a person can have a home/work/holiday name with the
associated addess.

I have code in the format of the detail section to populate name address city
state and zip.  It works just fine until I go to the second letter and the
same info is on each letter.  It seems like that it starts at the beginning
of the recordset each time a new letter is ...

I have made a Report from my data which ended up looking like a spreadsheet.  
It has multiple fields side-by-side within the detail section.  One of the
fields is a memo field that I have set "Can Grow" to yes because some of the
data can become lengthy.

Following is a previous thread with code.  This works but makes all letters
the same address as the first.  How do I get it to do the same functionality
for each record.
here is the code:

I am trying yo setup a report.  This report is to show all of the employees
that are enrolled in  a class by Date, Instructor & Class.  When I run the
report, the header only shows one of the instructors classes and the body
shows every employee even if they are being trained by ...

Responder NameI am working on a method for a database that a Fire Department
will use.  The problem I am having is that there should be a number beside
the record.  The Primary Keys are RUN No.  which is associated with
Responders (Run ID Repeated for each record associated with ...

I have four different fields that are yes/no checkboxes in my report.  The
fields are chk_firstAid, chk_physio, chk_FDvisit, and chk_SHMHvisit.  
At the end of the report I will do a sum of all four checkboxes, however the
user wants me to set it up with a tricky multiple if ...

I have a report that will be huge, like 25 pages on average.  I would like
to know if it is possible to break this report up into like 10 sections and
then use them to build the final product?  Is this possible, if so, does
anyone have any tutorials or examples?

I have a yes/no checkbox in one of my reports.  At the end of the report I
want to do a Sum for each checkbox that is checked.  I can't figure out how
to do this.  Is it possible and if so how?