Hi Groupies
All of my text boxes in the detail section are set to Can Grow. My problem
is that if one of the boxes needs to grow, I need the other text boxes to
grow to the same size. The box that usually needs to grow is called strName,

I'm of new to Access 2007. I have created a form and a report. Is it
possible to have the user use the built in filter Access provides and click
the report button and  print only that data. Each time I open the form
different data will need to be selected by the user.

The forms and reports in the project I am working on are unbound. So
far, I have been using ADO recordsets. I'm using Access 2003 with a
separate FE and BE.
I have a form where the user sets up what data he wants to see on the

Currently writing a report to produce a label based on records in a table.
Got an orders table with a label table linked by the PK, PURCHASE_ORDER and
PART_NUMBER.
Firstly, I produced a form that the user selects the order number and then

I created a report for a query.  When I sort the desired field most of the
records sort correctly, but some records do not.  This phenomenon happened
both in the query and the report.  I was able to solve the query sort problem
by highlighting the column in the data set view and ...

I have a report based on a crosstab query and need to calculate what % a sub
set of the columns is of the total in each detail row.
I have tried creating a text box where the data is Sum([1]+[2]+[3]
etc)/Total but the text box returns a blank.

This took me just short of forever to figure out what my real problem
actually is.  I have a microsoft access database using the ReportToPDF
function found at http://www.lebans.com/reporttopdf.htm.  An amazing little
program.  On my development machine, a 2003 server (without ...

I have a report defined as landscape.  However, it occasionally
generates as portrait.  Has anyone encountered this?  What to do?

I want to do a report indexed to a certain ID. And for each ID this report
has to create multiple charts. The problem is: the legend that is shown in
the chart does not assume all data range, especially if they are zero! That
becomes the interpertation harder because for one ID I ...

I have a totals query that sums [payments] [fees] and [adjustments]. A report
based on this query displays the results. On the report I have a field that
calculates the balance: [fees]-[payments]+[adjustments]. I want to be able to
filter out any records that have a balance of ...

Is there a way to center a checkbox (Yes/No field) under the column heading
in a tabular report? The usual left/center/right alignments aren't available
and there doesn't seem to be an easy way to "unhook" the field control from
the field name control (Design view) to align the ...

I've created a report to show checks cleared for a certain month and want to
place an asterik next to a check number which is out of sequence.  Is there a
way to use a previous record value in an expression  =iif([check
no]-????([check no])<>1,"*","") ?

I'm writing some introductory data management labs for my college-level
computer literacy course and I'm having problems with the report wizard.
(Please don't lecture me on the benefits and pitfalls of using the report
wizard, if there are such things. I have many years of data ...

I am wondering if it is possible to accurately create sums in this
report:
I have 2 tables.  Orders and Order Details
Among other data, Orders contains a field "Total Income" which is the

I have a database in which I created a report from a query.  The query
and report ran fine.  I realized I forgot 8 fields on the report and
so I added them - just the controls, I didn't need the labels.
Now my query is still fine, but when I try to run the report I get the