Multi-page forms

[Jim Burke in Novi]

I am designing a report that is actually just two forms, with a total of six
pages. There are a couple of fields that have data from a data source, but
for the most part it is just hard-coded fields for forms to be filled out by
patients. I got my first two pages designed, but when I go to start the third
page, it won't allow me even one more full page. It stops at 22 inches - it
won't let me scroll down any further. HOw do I go about designing a six page
report that is pretty much all hard-coded fields? Any help is appreciated.
Thanks.

Jim B

 

[Allen Browne]

The 22" limit is per section.
If you need more, add sections.

Let's assume the report is bound to your patients table, with a PatientID
primary key. In the Sorting And Grouping box, choose the PatientID field,
and set Yes for both Group Header and Group Footer. Access adds a Group
Header above the Detail section, and a Group Footer below it.

You now have 3 sections, each up to 22" high.
Ergo, 6 x 11" pages.
And since these sections repeat for every patient, you get the complete 6
pages for each person.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

message
news:[email protected]...