1. I have check boxes included in a report and want to
remove the borders and just leave the tick.  How can i do
this?
2. I have provision on a report for up to 6 childrens

There was an earlier post dated 10/04 where the question was why are the sub
reports duplicating the data?  The response was to check the Child/Master
fields on the sub reports.  I don't understand what this property has to do
with creating a sub report.  I have two reports that ...

I have two combo boxes in a form, cbxMonth and cbxYear that requires user to
input the month and year. Based on this input, a report will be displayed
showing transactions for the particular period. This is my code, but it
doesn't work:

I am pulling a report from a query based on 4 tables.
[Report] 1:M [Maintenance] 1:M [Composite Table] M:1 [User]
The report is grouped and sorted as follows:
Report

I keep seeing signatures from several individuals that have the
"Access MVP" tagline. What's that all about?  Something official,
or self-proclaimed?
In addition, keep up the GREAT work.  Everyone's help is truly

i am working with a new database in which apartment information is kept.  
there are forms and subforms all over the place.  when i produce reports,
there is one hall that does not produce the suites in chronological order.  
the problem is that i cannot locate where to correct the ...

Hi Experts,
In need to design a report where each character of the report data (almos
all of them) needs to be displayed in a seperate box. The number of boxes
are pre-set for each report item thus parsing stops when data string length

Is it possible to have combo box pull up a value and then a query populate a
subform located on the same form?  
The subform would be based on a query with a field having the combo box as
its criteria.

Having difficulties creating a report text field that is comprised of
multiple fields.  Example of control source:    =[RFI No 1] + ", " +[RFI No
2] + "' " +[RFI No 3].  The problem I am having is when the record [RFI No #]
is null the whole text returns as empty.  What is the ...

I am wondering if there is a way, or if someone can hlep me devise a way to
ignore the word "THE" when sorting a report.  The field that it is sorting on
is a "Title" filed.  The title of the book could be, "The Owners Manual".  
When the report is run, that title is placed with ...

Using Access 2003
I created a "Find Unmatched Query Record" Query and then
created a report based on that query.  When there are NO
unmatched records, (instead of the record being blank) I

Help!
I have a db with 4000+ records.  When I print reports, I want to have the
ability to print all the records or only one particular group without first
having to scroll through print preview to find out the page range.

Access 2002, Windows 98
I am using code to ouptut a snapshot report onto my server.  I am using the
DoCmd.OutPutTo
This was working fine.  Then I went to view snapshots and installed the

I have a lot of reports.  I want to make one master report that has all of
the other subreports, but some of them are landscape and some are portrait -
is there a way to set Access to have different layout options for each page?  
The main reason I want to know (and the main ...

The table is transaction and has Type as one of its columns, so as I enter
data, I'm entering rows of data for different TranTypes.  There is one
instance where I will only have two rows of data for two different tran types
and I want to make a report with those types as column ...