How to make long report (report.detail.Height limits?) 1

[taaltio]

I need to make a report which contains aprx. 300 "text box":es. (Access 2002)

Currently I have them all in one report, in same 'detail'-section. How can I make a report, where they all fit?
Tried so far:
-make detail section longer: can't do, Access doesn't allow over 55.8cm report.detail.height.
-Make text-boxes maximally flat, and use property 'can grow'=yes. They still dont fit.
-Use sub-forms. I dont know houw it would help.
-divide same report to several 'reports'. Works, isn't there better way? impractical.

any suggestions?

 

[dhookom]

You can create additional detail sections by setting your lowest sorting and grouping level to a value that is unique to every record ie: the primary key. Show this groups header and footer and you end up with two more detail sections.

I will assume your table is properly normalized and you just need this many controls/fields.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[taaltio]

No normalization issue here. I'm trying to print only one record! It contains all customer data concerning one customer-visit, hundreds of check boxes and text-boxes. (Database contains hundreds of customer visits.).

 

[taaltio]

thanks "dhookom", additional detail sections solved the problem. Trick was to put data to new 'header'-sections of the report. (in "sorting and grouping" add as many as necessary : Field/expression=myCustomerID, Group Header=yes. )

 

[dhookom]

taaltio,
Hundreds of check boxes and text boxes sounds very un-normalized to me. If you have 110 check boxes that describe different characteristics regarding your customer visit, why not 111 or 108 if you find a few aren't important any more. I could be wrong but I expect whoever created this table was "committing spreadsheet".

If this works for you, then go for it. I can't recall creating a table with over 30 fields.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[taaltio]

Here is a part of the questionary, so you can see why there are so many check boxes (poorly translated from finnish):

several options may be selected for each question.

1. services that customer has previously used:
1.2 hospital
1.3 police
1.4 social worker
1.5 wellfare
1.6 AA
1.7 drug rehab.
...etc

2 Problems which the customer thinks have escalated the violence:
2.1. difficulties to discuss problems
2.2. drugproblem
2.3. unemployment
2.4. jealous to spouse
2.5. jealous to children
2.6. ilness, specify:___________
2.7. religious differences
2.8. other problmes, specify:__________
...etc
goes on and on...

This form is about 8 pages on paper.
I quess there is no way no normalize this ?

 

[dhookom]

Awk! You are storing data values in field names. I would not create a table where if I wanted to track additional "Problems which the customer..." I would have to create additional fields, controls on forms, fields in queries, controls on reports,...
For instance, there should be a table of customers
tblCustomers
=======================
cusCusID autonumber primary key
cusFirstName
cusLastName
cusDOB
cus...

tblServices (1 record per service)
===================
srvSrvID autonumber primary key
srvTitle values like "hopital", "police",...
srvActive is this still being tracked

tblCustServ (1 record per customer per service)
====================
csvCSvID autonumber primary key
csvCusID long int related to tblCustomers
csvSrvID long int related to tblServices
csvStartDate 'optional field
csvEndDate 'optional field
csvPrvID optional link to table of service providers

You would do exactly the same for the problems. If you need to add more services, this is done with data entry, there should be no significant changes to tables, forms, or reports.

There is a sample survey application at

http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane

that might provide a similar sample.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.