I can't seem to get this code to work and I am wondering why? I am trying to
set the textbox values to all uppercase letters. Please expain. ?:-(
Dim ctl As Control
   For Each ctl In Me.Controls

I'm working on my first Access 2000 report, actually an invoice-type single
page print.
The detail lines are previewing and printing twice, each line repeats before
printing the next line twice.

When creating my database, I made one field a "number" field.  When I put in
41.5, it rounded up.
Aside from making it a text field, I couldn't get the field to stop rounding
up.

What is the technique for printing a memo of unknown length?  Currently, my
report has space for three lines of text for this field.  Short memos have
two blank lines of text, and long memos are truncated.  I want to make sure
that long memos are not truncated.

I would like to enter a sorting reference into a report. Our customer numbers
are looking like the following: 43001000-6000 . Only the last four numbers
are counting up (6000,6001,6002,6003 ... etc) the first 8 numbers are
sometimes different.

I need to create a report where the column headings change in this case week
numbers with data falling below this.  However when the week changes I have
to create a new report.  How can I get around this???  Please help it is such
a waste of time!!!

I have a database with our subcontractors and the hours that they worked
daily.  What I need to do is get a report to total the hours that the
subcontractor worked in a month - with each subcontractor on its own page.  
The page needs to show the subcontractor's name and the dates ...

I'm trying yo keep a running count of only certain records in a report.
Here's the situation, I have a report with say 50 records. One of the fields
is "referral date". I want to have a running sum of the number of these 50
records that have a "referral date" within a certain range. ...

I have created a weekly summary report that totals the number of records per
job code and their percentages in relation to the total number of records (no
problem here) However, if a job code is not used a record is not generated
for that particluar job code. This "unused" job ...

Hi I using the following syntax in a text box on an Access report.  I am
getting and error message, either syntax or quote marks.
Can some kind person tell me what is wrong please- thanks
="Thank you for your recent enquiry - we have pleasure in enclosing " &

Hi, can someone help me?
My query is sorted correctly! - but the report based on that query shows a
total different sorting - how can that happen?
Thanks

I am having problems using an IF statment on a report. I'm trying to
calculate a value using only certain criteria. For example, in a text box I
have =IF([field in table],"name of criteria",sum([name of field]*number,"")
when I run the report I get a parameter box asking for IF.

Below is the expression for calculated control in the group footer of the
Main Report. The fields referred to are contained in seperate subreports. The
problem is that when one or more of the subreports does not contain any
records the calculation returns a null result. The ...

I am working on an .adp file in Access 2003 connected to a SQL Server 2000
database for a film storage facility.  The report that is giving me trouble
is an inventory list displaying all reels belonging to a selected customer,
grouped by title.  It is a pretty simple report and ...

I want the customer group footer to always be at the bottom of the page,
regardless of the number of line items.  The footer holds the customer total
for an invoice.  I don't want the invoice format to shrink to half a page if
there is only one line item, and there may be enough ...